>How to delete multiple table in one query ?

Simple answer, you don't.

To empty a table:

DELETE FROM <TableName>;

To remove a table completely:

DROP <TableName>;

For a more useful answer, please tell us more about what you want to do, DROP <TableName> is not something that you should do too often, and DELETE FROM <TableName> would typically include a WHERE clause.

Set