Hi, Check the behaviour of auto_increment in the change logs - it changed from using the highest available number to carrying on from where it left off some time ago, but I believe there is a was to reset it manually.
Hope this helps. Quentin Bennett Senior Analyst Infinity Solutions Ltd PO Box 3323, Auckland Ph: 09 921 8146 Fx: 09 309 4142 www.infinitytransport.net > -----Original Message----- > From: Louie Miranda [mailto:[EMAIL PROTECTED] > Sent: Thursday, 25 September 2003 2:58 p.m. > To: [EMAIL PROTECTED] > Subject: auto increment > > > I have a id_entry field that is doing auto increment on that > field. Now, when i try to delete the numbers it still > continues to count from where it left. > > ex: i have entrys > > 1|one > 2|two > > once i deleted 1|one on the field or even 2|two > > it still counts to 3|three and so on > > And is it also possible to change the values, to 2003-01 and > so on.. Im tired just using the numbers from 1 and so on.. > > > - > Louie > http://www.axishift.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
