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... Any thoughts? Is it something I'm doing wrong? ____________________________________________________ UNIX is user-friendly, it's just picky about who its friends are...
--------------------------------------------------------------------- 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
