获取指定数据中删除所有表的命令:
SELECT CONCAT("DROP TABLE IF EXISTS ", TABLE_NAME, ";")FROM information_schema.TABLESWHERE 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