常用维护SQL-数据清理

 truncate某个库的表数据

show full processlist;

select
concat('truncate table ',table_schema,'.',table_name,';') sqltext from information_schema.tables where table_schema not in ('mysql','information_schema','performance_schema','sys') and table_schema='vodb';
原文地址:https://www.cnblogs.com/perfei/p/10416913.html