Menu
Any help on re-ordering the columns in MySQL using phpMyAdmin? Is it called cardinality? I have created tables, but need to re-arrange the order of the columns due to an export script i have. It exports based on the arrangements. E.g. I want columns:
Apple | Cherry | Banana changed to:
Apple | Banana | Cherry 
230
Go to Structure and click Move Columns and then just drag the columns to rearrange.
In phpMyAdmin go to table structure. On bottom you can press option "Move columns" There you can rearange tables as you see fit. That one is for rearranging columns, not the tables themselves.
Just go to PHPmyadmin, click on your database, then click table. Then click on structure. Below the table look for the button, "Move columns". Click and order the columns the way you want.
phpMyAdmin has finally included this feature in the most recent version (4.0 and up).
Go to the "Structure" view for a table, click the Change button on the appropriate field, then under "Move column" select where you would like the field to go.
189
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
