Search This Blog

Wednesday, June 28, 2017

Rename a table in MySQL

Renaming a table is the easiest job. Here's how to do it:

RENAME TABLE myfirsttable TO users



The above query will rename existing table myfirsttable to users.