常用维护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';