Is this a test db? If so go ahead and drop your records so there are noneDeleting the records isn't sufficient to reset an autoincrement field.
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.
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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
