Atomic RENAME & Table Reload
No other sessions can access the tables involved while RENAME TABLE executes, so the rename operation is not subject to concurrency problems.
Atomic Rename is especially for completely reloading a table without waiting for DELETE and load to finish:
Change root password
Useful for scripting to drop all tables and deletes the database:
Use with extreme caution.
To DROP database as a SQL Script (you will need DROP privilege on that database):