Drop multiple tables in one shot in mysql

mysql sql multiple-tables drop-table
Krunal picture Krunal · Feb 7, 2011 · Viewed 128.9k times · Source

How to drop multiple tables from one single database at one command. something like,

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

where a,b,c are the tables from database test.

Answer

Leniel Maccaferri picture Leniel Maccaferri · Feb 7, 2011

Example:

Let's say table A has two children B and C. Then we can use the following syntax to drop all tables.

DROP TABLE IF EXISTS B,C,A;

This can be placed in the beginning of the script instead of individually dropping each table.

Related questions

sql - insert into multiple tables in one query

assuming that i have two tables, names and phones and i want to insert data from some input to the tables, in one query- How can it be done? Please, if it can be done, explain the syntax.

Read More
MySQL: how to drop multiple tables using single query?

I want to drop multiple tables with ease without actually listing the table names in the drop query and the tables to be deleted have prefix say 'wp_'

Read More
MySQL JOIN 3 tables using multiple columns/keys

Complete newbie to mySQL. So any help will be appreciated. I have 3 tables -- carts, users, actions. carts: +------------+-------------+-------+ | cartId | session_id | userId| +------------+-------------+-------+ users: +----------+-------------+ | usedId | email | +----------+-------------+ actions: +-------------+------------------+---- ---------+ | …

Read More