Re: alter table move column syntax error

[Peter Brawley]

We can't just make up syntax. The manual (http://dev.mysql.com/doc/refman/5.7/en/alter-table.html) says ...

ALTER TABLE MODIFY [COLUMN] col_name column_definition [FIRST | AFTER col_name]

And while you're at it, year decimal(4,0) is not optimal; look up the year datatype, or if there are portability requirements consider year smallint.

so you need ...

alter table car_table modify column year year null after color;