[Django] MySQL 테이블 전체 삭제

$ mysql -uroot -p

mysql>

SET @tables = NULL;
 SELECT GROUP_CONCAT(table_schema, '.', table_name) INTO @tables
   FROM information_schema.tables 
   WHERE table_schema = 'DB명'; -- specify DB name here.
 SET @tables = CONCAT('DROP TABLE ', @tables);
 PREPARE stmt FROM @tables;
 EXECUTE stmt;
 DEALLOCATE PREPARE stmt;

 

---

Reference

https://bizmark.co.kr/setup-and-tips/mysql/mysql-테이블만-전체-삭제-하는법/

Mysql 테이블만 전체 삭제 하는법 - IT infomation