You can change tables name in mysql
Syntax:-
RENAME TABLE old_table_name TO new_table_name;
Example:-
RENAME TABLE homedetails TO details;
Here homedetails is old table name and details is new table name.
Note:-
# Data will not effected by renaming table name.
# We can use any word as table name.
# Table name can be combination of Character and number but not number only.
# Number can be used as 1st digit in table name.
Thanks
ReplyDelete