I realize that this might be problematic/devastating if you had an AI PK and did this, however in my case there is no problem as there is no related data in the database yet lol.
My question is, how can I reset AI? For example I deleted several rows and now my AI starts with the AI number after the last row that was deleted. Ie. 1,2,3,4,9,10,11 when I want to start numbering at 5 not 9! Even if I insert/update with non-nulls then the sequence is still pushed ahead. Is there a way to reset this? Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]