Mysql 데이타베이스 내의 모든 테이블 삭제 스크립트

SET FOREIGN_KEY_CHECKS = 0; 

SET @tables = NULL;

SELECT GROUP_CONCAT(table_name) INTO @tables

  FROM information_schema.tables 

  WHERE table_schema = '[이곳에 DB명]';

SET @tables = CONCAT('DROP TABLE ', @tables);

PREPARE stmt FROM @tables;

EXECUTE stmt;

DEALLOCATE PREPARE stmt;

SET FOREIGN_KEY_CHECKS = 1; 

출처 : http://stackoverflow.com/questions/12403662/how-to-remove-all-mysql-tables-from-the-command-line-without-drop-database-permi