In MySQL, a single DROP TABLE statement can name several tables to be dropped simultaneously
DROP TABLE t1, t2, t3;