NYCPHP Meetup

[Peter Sawczynec]

Thank you. 

-----Original Message-----
From: talk-bounces at lists.nyphp.org [mailto:talk-bounces at lists.nyphp.org] On
Behalf Of Alberto dos Santos
Sent: Friday, March 17, 2006 4:21 AM
To: NYPHP Talk
Subject: Re: [nycphp-talk] Save Me From MySQL Self


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/f20397cc/attachment.html>