Is there any way to seed a column set to autoincrement? Say I wanted it to begin at 10000.
----- Original Message ----- From: "Greg Donald" <[EMAIL PROTECTED]> To: "wael fareed" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, July 06, 2003 4:42 PM Subject: Re: need help > > > my coulmn (id) is an auto_increment coulmn and lets say that i have 100 > > entries, so the problem is that when i delete all entries on my table, the > > column (id) starts from 101 ,shouldn't is starts from 1 again! > > please i need help with this > > Use truncate table, it will reset the auto_incement. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]