From: "Philippe Poelvoorde" > [Note, > ALTER TABLE foo ADD userid integer unsigned NOT NULL auto_increment > BEFORE username, ADD PRIMARY KEY(userid); > does not seems to work, possibly a bug ? > ]
No, you forgot the DROP PRIMARY KEY ;-) ALTER TABLE `foo` DROP PRIMARY KEY, ADD `userid` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT FIRST, ADD PRIMARY KEY(`userid`); works like a charm (MySQL 4.0.23-standard). Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
