清除数据库内所有表的数据【MySQL】
-
- drop procedure IF EXISTS delAllTableData;
- delimiter $$
-
- create procedure delAllTableData(tableName varchar(255))
- begin
- declare i int default 0;
- declare table_size int default 0;
- declare table_name_param varchar(255);
- SELECT count(*) into table_size FROM information_schema.tables WHERE table_schema = tableName;
-
- while (i < table_size) do
- SELECT TABLE_NAME into table_name_param FROM information_schema.tables WHERE table_schema = tableName limit 1 offset i;
- set i = i+1;
- set @tem_table := concat('truncate table ',table_name_param);
- prepare tem_table from @tem_table;
- execute tem_table;
- end while;
- end $$;
- delimiter ;
-
- call delAllTableData('database_name');
-