How rename table name in mysql with example

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.

Previous Code:-
Delete row

List Code:-
Mysql Codes

Next Code:-
Delete table