MySQL Forums
Forum List  »  MySQL for Excel

Re: Insert column in existing Mysql database
Posted by: varun vikki
Date: October 24, 2015 12:46AM

An ALTER TABLE statement adding the PRIMARY KEY column works correctly in my testing:
ALTER TABLE tbl ADD id INT PRIMARY KEY AUTO_INCREMENT;

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Insert column in existing Mysql database
908
October 24, 2015 12:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.