Hi. This may be a obvious problem but... I want to re sequence a auto increment column called p_key starting with 1001. I found some information on this the Paul DuBois book MySql: I tried dropping the column and adding it again per there instructions:
ALTER TABLE t DROP i; ALTER TABLE t ADD i INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY; But It did not help as it does not start at 0 value but at the last value such as 1076 What do I need to do to get it to start again at 0 or at 1001? My mysql version is 3.23.38 running on redhat 6.2 Thanks, Mark _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
