MySQL Forums
Forum List  »  Newbie

question on adding column
Posted by: MySQL Student
Date: July 04, 2010 08:53AM

I added a column to an existing table

alter table add my_key int auto_increment primary key

it worked and the column got added fine.

However what I wanted to do was to make this column as the first column of the table.

Now that the column is already created, how do I now make it as the first column?

Options: ReplyQuote


Subject
Written By
Posted
question on adding column
July 04, 2010 08:53AM


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.