Change Column Name in MySQL

Question

After searching I can't figure out what I need to do in ALTER TABLE genres to change the col id to genre_id any ideas?

rahul has the answer, for reference see http://dev.mysql.com/doc/refman/5.1/en/alter-table.html — Patrick McDonald, Nov 19 '10 at 11:54
Does this answer your question? [Rename a column in MySQL](https://stackoverflow.com/questions/30290880/rename-a-column-in-mysql) — enharmonic, Aug 07 '20 at 20:25

score 12 · Accepted Answer · edited Dec 23 '13 at 05:50

12

alter table genres change id genre_id int(10) auto_increment;

edited Dec 23 '13 at 05:50

RAS

answered Nov 19 '10 at 11:52

XMen

@Johnny ALTER TABLE record CHANGE id genre_id INT(10) AUTO_INCREMENT ; add auto_increment – XMen Nov 19 '10 at 11:57
Ok it didn't keep the definitions. – Johnny Nov 19 '10 at 11:58

1 Answers1