NYCPHP Meetup

[Alberto dos Santos]

iIf you are any bit as stressed about wellformdness (??) of your data
records as I am (nobody is perfect) you'd export the dataset onto a text
file, remove the numbering and re-import into a newly made table, and auto
numbering just picks up from the begining...

On 16/03/06, Jon Baer <jonbaer at jonbaer.com> wrote:
>
> There is already a SIG list for MySQL ...
>
> http://lists.nyphp.org/mailman/listinfo/mysql
>
> I find the main lists and the MySQL forums pretty quick/responsive ...
>
> http://lists.mysql.com/
> http://forums.mysql.com/
>
> As for the question I beleive phpmyadmin has an operation for this +
> looking it up the call is something like ...
>
> ALTER TABLE t AUTO_INCREMENT = x
>
> The last time I did something similar I attached a temp_id field and
> looped through + set it, dropped the pk(id) field and renamed, this
> was not a large dataset however.
>
> - Jon
>
> On Mar 16, 2006, at 1:07 PM, Peter Sawczynec wrote:
>
> > In order to avoid my flooding this PHP list with MySQL questions, can
> > someone please point me to a fast-acting MySQL list where
> > questions/issues get addressed just as quickly and dynamically as
> > they do
> > here on the premiere NYPHP list.
> >
> > For example, I need to know:
> >
> > If I have a MySQL table with, say, 200 rows of entries already in it.
> > The table has been using auto-increment.
> > Client wants to manually re-number these first historic 200 entries
> > according to how they were numbered 1-200 when originally entered
> > by hand in
> > the paper ledger.
> > So, can I just remove auto-increment with a table schema update.
> > Then manually rejuggle the numbers in the now dead auto-increment
> > field.
> > Then put auto-increment back and MySQL will happily start auto-
> > incrementing
> > again at 200 without a hitch.
> >
> >
> > Warmest regards,
> >
> > Peter Sawczynec,
> > Technology Director
> > PSWebcode
> > _Design & Interface
> > _Ecommerce
> > _Database Management
> > ps at pswebcode.com
> > 718.796.1951
> > www.pswebcode.com
> >
> > _______________________________________________
> > New York PHP Community Talk Mailing List
> > http://lists.nyphp.org/mailman/listinfo/talk
> > New York PHP Conference and Expo 2006
> > http://www.nyphpcon.com
> > Show Your Participation in New York PHP
> > http://www.nyphp.org/show_participation.php
> >
>
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
> New York PHP Conference and Expo 2006
> http://www.nyphpcon.com
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
>



--
Alberto dos Santos
Consultor em TI
IT Consultant

http://www.yournway.com
A internet à sua maneira.
The Internet your own way.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20060317/6fc95674/attachment.html>