Delete all tables under MySQL specified database

1. First run the following code
SELECT concat (' DROP TABLE IF EXISTS ', table_name, '; ')
From Information_schema.tables
WHERE table_schema = database name;

2. The query is similar to the result
Concat (' DROP TABLE IF EXISTS ', table_name, '; ')
DROP TABLE IF EXISTS clients;
DROP TABLE IF EXISTS invheader;
DROP TABLE IF EXISTS invlines;
DROP TABLE IF EXISTS items;

3. Copy this query result and paste it into the SQL execution window to delete all the tables below the database.

Delete all tables under MySQL specified database