rename table

Sometimes you may need to change a table name in MySQL. Here is how to rename table in MySQL.