MySQL 删除数据库中所有表、所有存储过程命令

获取指定数据中删除所有表的命令：

SELECT CONCAT("DROP TABLE IF EXISTS ", TABLE_NAME, ";")
FROM information_schema.TABLES
WHERE table_schema = "gamedb";

输出为：

+--------------------------------------------------+
| CONCAT("DROP TABLE IF EXISTS ", TABLE_NAME, ";") |
+--------------------------------------------------+
| DROP TABLE IF EXISTS mailinfos0;                 |
| DROP TABLE IF EXISTS mailinfos1;                 |
| DROP TABLE IF EXISTS mailinfos2;                 |
| DROP TABLE IF EXISTS mailinfos3;                 |
| DROP TABLE IF EXISTS mailinfos4;                 |
| DROP TABLE IF EXISTS mailinfos5;                 |
| DROP TABLE IF EXISTS mailinfos6;                 |
| DROP TABLE IF EXISTS mailinfos7;                 |
| DROP TABLE IF EXISTS mailinfos8;                 |
| DROP TABLE IF EXISTS mailinfos9;                 |
| DROP TABLE IF EXISTS mailinfos_system;           |
| DROP TABLE IF EXISTS playerbasedata;             |
| DROP TABLE IF EXISTS playerchapterdata;          |
| DROP TABLE IF EXISTS playerequipdata;            |
| DROP TABLE IF EXISTS playeritemdata;             |
| DROP TABLE IF EXISTS v_mailinfos_all;            |
+--------------------------------------------------+
16 rows in set

获取指定数据中删除所有存储过程的命令

SELECT CONCAT("DROP PROCEDURE IF EXISTS ", ROUTINE_NAME, ";" )
FROM information_schema.ROUTINES 
WHERE ROUTINE_SCHEMA='gamedb';

输出为：

+---------------------------------------------------------+
| CONCAT("DROP PROCEDURE IF EXISTS ", ROUTINE_NAME, ";" ) |
+---------------------------------------------------------+
| DROP PROCEDURE IF EXISTS AddNewMail_ForOne;             |
| DROP PROCEDURE IF EXISTS AddNewMail_ForSYS;             |
| DROP PROCEDURE IF EXISTS CreatePlayerData;              |
| DROP PROCEDURE IF EXISTS LoadPlayerOtherData;           |
+---------------------------------------------------------+
4 rows in set