Java Proficiency: rename example in mysql

Showing posts with label rename example in mysql. Show all posts

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