RENAME Table AND Column Name In Mysql Database

Rename Table Name In Mysql:

RENAME TABLEĀ  old_name_of_table To new_name_of_table;

Example:

RENAME TABLE user12 To user;

Rename Column Name IN Mysql

ALTER TABLE Table_name CHANGE Old_column_name New_column_name DataType

Example:

ALTER TABLE user CHANGE name user_name varchar(100);

Leave a Reply

Your email address will not be published. Required fields are marked *

5 + 4 =