Monday 13 April 2015

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);

No comments:

Post a Comment