Hi David, ALTER TABLE table ADD ListingID MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
That will add the column at the beginning of the table (first column). Remove "FIRST" from the end if you don't want that (it will then go at the end) or replace it with: AFTER some_other_column Also sending this to the General list since it isn't a Windows specific question. :-) Matt ----- Original Message ----- From: "tooptoosh" Sent: Wednesday, February 04, 2004 1:54 PM Subject: mySQL autogenerate, update table Hi all, I have a mySQL table with 75,000 records in it, but the table has no primary key (autogenerate) column in it. I want to add this field column "ListingID" to the table. How do I do that? Cheers, David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
