朱赤墨黑

select concat('truncate table ',TABLE_NAME,';') from information_schema.`TABLES` where TABLE_SCHEMA='rks_rpsdb' and TABLE_NAME like 'O_%'

效果图：SQL： select to_char(ADD_MONTHS(TO_DATE(d.time,'YYYY-MM') ,-12),'YYYY-MM') pretime,d.base as predata,d.time ,d.num as data,nvl2(d.yoy,concat(d.yoy, '%'),'—') as yoy from ( select c.year||'...