DELETE from TABLE_NAME where xxx
select concat(round(sum(DATA_LENGTH/1024/1024),2),'M') as table_size from information_schema.tables where table_schema='csjdemo' AND table_name='demo2';
optimize table demo2
Truncate table TABLE_NAME
Drop table Tablename