Suppose I have a table with:
id int(11) auto_increment,
date datetime,
created_at datetime
and want’s to have this arrangement:
id int(11) auto_increment,
created_at datetim,
date datetime
This will be the command to do just that.
ALTER table test.date MODIFY COLUMN created_at date AFTER id
