Alter table....modfiy column.... command should do it. Regards, Bhavin. ----- Original Message ----- From: "Jason Lane" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, June 09, 2002 2:50 PM Subject: RE: Can I override the auto-increment setting?
> I have a mysql table that has the primary key set to auto-increment. For > a > very strange reason we have a row with the primary key value of 0. This > is like a default value for the application. I didn't want to do it this > way, but it's too late now. > If the 0 value doesn't exist we have to create it. The problem is that > if I try to INSERT or REPLACE and the 0 value doesn't exist, it inserts > the record with an auto-increment value, not 0. > IS there a way to temporarily turn off Auto-Increment on the table? Just > long enough for me to do my REPLACE and then turn it back on? > > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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