Jump to content


This topic is now archived and is closed to further replies.


Adding columns to tables in the correct place

Recommended Posts

i want to add some columns to me table after other columns already exsistent in the table. I know the following command works:

alter table tablename add column columnname ... first;

This puts the column at the beginning of the table. How do i place it so its the third column in the table or so that it is after another column??

Share this post

Link to post
Share on other sites
[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']ALtER TABLE[/span] tablename ADD newcolumn ... AFTER othercolumn [!--sql2--][/div][!--sql3--]
[a href=\"http://dev.mysql.com/doc/refman/4.1/en/alter-table.html\" target=\"_blank\"]http://dev.mysql.com/doc/refman/4.1/en/alter-table.html[/a]

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.