【mysql】删除mysql某个库下的所有表
1、获取某个库下所有需要删除的表
SELECT
concat(
'DROP TABLE IF EXISTS ',
table_name,
';'
)
FROM
information_schema. TABLES
WHERE
table_schema = 'david_woshi_dbname';
2、然后执行输出的删除命令即可。如：
DROP TABLE IF EXISTS t_cms_jiaochengziyuancn;
SELECT
concat(
'DROP TABLE IF EXISTS ',
table_name,
';'
)
FROM
information_schema. TABLES
WHERE
table_schema = 'david_woshi_dbname';
DROP TABLE IF EXISTS t_cms_jiaochengziyuancn;