MySQL Forums
Forum List  »  MySQL Administrator

Re: Howto add/remove columns in Table Editor
Posted by: Barry Galbraith
Date: July 16, 2009 11:26PM

To add a column, open the table with the table ditor, click in the space under the last column, and add your new column.
To delete a coulmn, select the column to delete, right click, and select "Delete table columns.
To re-order, why do you think you need to re-order?
The whole point of SQL is that you can retrieve the columns in any order you want, regardless of the order they are stored.

But, if you *really* want to re-order the columns, there is a description of how to do it in the MySQL user guide.

http://dev.mysql.com/doc/refman/5.0/en/change-column-order.html

See the comments at the bottom of the article too.

Good Luck.
Barry

Options: ReplyQuote


Subject
Written By
Posted
Re: Howto add/remove columns in Table Editor
July 16, 2009 11:26PM


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.