How to insert new column in the middle, or on top of other columns?
How can I insert new column in the middle, or on top of other columns, using MySQL Administrator Table Editor? I can add new columns only at the bottom of the column list. If I want to insert the new column in the middle, I have to switch to Query Analyzer and key in the SQL command manually. This is just a matter of preference, I know, but still ...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
teraplane,
That's what I'm currently doing. After I click "Apply Changes" in Table Editor, it will show me the equivalent SQL statement that will do the changes. I copy and paste it to the Query Analyzer, modify the AFTER section, manually. Now, I'm wondering if it can be done through the Table Editor GUI?
fibo,
You answered your own question :)
And sometimes I want to place columns that are "related" (not in RDBMS sense) nearby each other, so that it's easier to see.
That's what I'm currently doing. After I click "Apply Changes" in Table Editor, it will show me the equivalent SQL statement that will do the changes. I copy and paste it to the Query Analyzer, modify the AFTER section, manually. Now, I'm wondering if it can be done through the Table Editor GUI?
fibo,
You answered your own question :)
And sometimes I want to place columns that are "related" (not in RDBMS sense) nearby each other, so that it's easier to see.
ASKER
Not possible?
I'll wait for another 2 days ...
I'll wait for another 2 days ...
The only case in which this might have an impact is that it is better to have all the VARCHARS at the end of the columns. Otherwise, none of you SQL queries is affected by the order in whixc you name the fields