mysql - rename column name and change order of columns in table
ALTER TABLE customers CHANGE NAME first_name VARCHAR(50) ;
ALTER TABLE customers MODIFY phoneno INT AFTER last_name;
Change column name in
mysql
Lets change name in the
customers table
to first_name
How to change the order
of columns?
bring phoneno to the last
position