I have a column name called ‘order’ in two of my db tables.
I have just realized that it is causing some problems since ‘order’ is
a reserved word in mysql.
Unfortunately, trying to run a migration that includes…
rename_column :images_piles, :order, :sequence
…results in a mysql error (see below). Is there anyway way to run a
successful migration that forces mysql to treat ‘order’ as a column
== ChangeOrderToSequence: migrating
– rename_column(:images_piles, :order, :sequence)
Mysql::Error: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near ‘order sequence int(11)’ at line 1: ALTER TABLE images_piles
CHANGE order sequence int(11)