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