Drop multiple tables in one shot in MySQL

Question

How to drop multiple tables from one single database at one command? 

> use test; 
> drop table a,b,c;

Where a,b, and c are the tables from the database test.

Answer 1

The following syntax can be used to delete several tables at once:

DROP TABLE IF EXISTS B,C,A;

Instead of dropping each table one by one, this might be added at the beginning of the script.