Yamin, Monday, July 22, 2002, 11:15:30 AM, you wrote: YP> I had a auto increment column YP> let say the auto increment would look like this YP> 100,1001,1003,1101,1103,10005,10006
YP> yes I had delete several column in tha past YP> now I would like to sort it again so it would be an order from 100 to 1006 YP> is it possible for mysql to do that with out drop the column first ?? In general you can, f.e: SET INSERT_ID=100; ALTER TABLE table_name ADD COLUMN id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY FIRST; but I think it's a not an efficient way ... Why do you want to change the numbering of the column? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.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