Tip: Easily reordering columns in MySQL
I’ll sometimes get columns out of order because of Rails migrations.
Tip: you can drag and drop columns in Sequel Pro on the “Structure” tab to resolve this type of thing. (No need for running a query that does
And just a reminder, you can add columns with the
AFTER syntax to specify where in the table they appear:
add_column :name, "VARCHAR(255) AFTER title"