SELECT concat(`TABLE_SCHEMA`,'.',`TABLE_NAME`) FROM information_schema.`TABLES` WHERE TABLE_SCHEMA ='kf_financial' AND `TABLE_NAME` like 'cm_hebao_xx_deduction_%'
1.代码SELECT concat(`TABLE_SCHEMA`,'.',`TABLE_NAME`) FROM information_schema.`TABLES` WHERE TABLE_SCHEMA = 'kf_financial' AND `TABLE_NAME` like 'cm_hebao_xx_deduction_%'2.执行效果