MySQL忽略外键约束删表

1. 生成删除的sql

SELECT
	concat(
		'DROP TABLE IF EXISTS ',
		table_name,
		';'
	)
FROM
	information_schema. TABLES
WHERE
	TABLE_NAME IN (
		...
	);

2. 进行删除

SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS tablename;
DROP TABLE IF EXISTS tablename;
SET FOREIGN_KEY_CHECKS = 1;