RENAME Table AND Column Name In Mysql Database

Rename Table Name In Mysql:

RENAME TABLEĀ  old_name_of_table To new_name_of_table;


RENAME TABLE user12 To user;

Rename Column Name IN Mysql

ALTER TABLE Table_name CHANGE Old_column_name New_column_name DataType


ALTER TABLE user CHANGE name user_name varchar(100);

Leave a Reply

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

− 4 = 3