Re: insert: auto increment field

[Mike Mapsnac]

It solved the problem. But what truncate does? Just deletes the rows?



From: Daniel Kasak <[EMAIL PROTECTED]>
To: Larry Brown <[EMAIL PROTECTED]>,        Mike Mapsnac 
<[EMAIL PROTECTED]>, MySQL List <[EMAIL PROTECTED]>
Subject: Re: insert: auto increment field
Date: Mon, 05 Jan 2004 11:18:08 +1100

Larry Brown wrote:

Is this a test db?  If so go ahead and drop your records so there are none
in there and start entering them and checking their id as you do.  After
dropping all records it should start back at 1 and increment forward.  I
don't know how the index went up to max for that field.  Perhaps something
during previous tests.  If you can't drop the current records document 
that
in your reply and maybe someone else can give another suggestion.


Deleting the records isn't sufficient to reset an autoincrement field.
You should do a 'truncate table my_table_name' to reset an autoincrement 
field ( I believe this does a drop table / recreate table process ).

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
_________________________________________________________________
Make your home warm and cozy this winter with tips from MSN House & Home.  
http://special.msn.com/home/warmhome.armx

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]