How rename table name in mysql with example

You can change tables name in mysql


RENAME TABLE old_table_name TO new_table_name;


RENAME TABLE homedetails TO details;

Here homedetails is old table name and details is new table name.


# 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.

Previous Code:-
Delete row

List Code:-
Mysql Codes

Next Code:-
Delete table

One Comment

Add your comments here

Back to Top