what is the effects of renaming a mysql table? code example

Example: rename table in mysql

RENAME TABLE old_table TO new_table;