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

One Comment

Add your comments here

Back to Top