How to Change a Column Name in MySQL

You rename a column in MySQL using alter table and change. Let's say our column is currently named soda but you decide that beverage would be a more appropriate title. This column is located on the table called menu. Here is an example of how to change it:

alter table menu change soda beverage varchar (10) ;

alter table tablename change oldname newname varchar (10) ;

• learning mysql databases
• column name
• editing mysql