moving columns??

[browni]

Hello guys,
I need some help from you i.e. how to move a column in a table up or down the list of columns in the table, using MySQL Administrator? Hope someone knows about it !!!!
Thanks in advance -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Saggie]

Move your columns by altering your table. Also, to move a column you need to declare it again and then can tell where it belongs e.g. to change Col1, Col2 & Col3 to Col1, Col3 & Col2:

alter table
yourtablename
change col3 col3 varchar(15)
after col1 -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --