From: "bruce" > table foo > username varchar(50), primary > > what i want... > userid int(), primary > username varchar(50) > > with userid listed before username!! > can someone tell me what the commands are that i need to enter to get this!!
http://dev.mysql.com/doc/mysql/en/alter-table.html ALTER TABLE `foo` DROP PRIMARY KEY, ADD PRIMARY KEY (`userid`); Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
