On Wed, Jun 06, 2001 at 07:02:52PM -0700, Tyrone Mills wrote:
> SQL, QUERY
>
> I posted a little while back with a problem on several tables where
> the autoincrement column reverted to zero for no apparent
> reason. Now I know the reason, I just don't understand it, or know
> what to do differently.
>
> I find myself in the all too common situation where I can developing
> a backend system with a spec that changes more frequently than I
> care to mention. As a result I find that I am often required to add
> columns to tables on a live, production database. Today, after
> adding a column to a table, the very next insert into that table
> resulted in a value of 0, any subsequent inserts also try to use
> 0...
That's odd. I've altered tables in the past an not had auto_increment
columns revert to 0. Can you show us the SQL for the table and the
ALTER TABLE statement you're running, maybe?
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
MySQL 3.23.29: up 12 days, processed 77,922,544 queries (72/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
