MySQL :: MySQL 5.0 Reference Manual :: 13.2.2 DELETE Syntax

No other sessions can access the tables involved while RENAME TABLE executes, so the rename operation is not subject to concurrency problems. See Section 13.1.20, “RENAME TABLE Syntax”. You can specify multiple tables in a DELETE ...

dev.mysql.com