比如,计算出 test 库中,以“GWGL_”开头的表名有多少个?
select count(*) from information_schema.TABLES where TABLE_SCHEMA='test' and
TABLE_NAME like 'GWGL_%';
比如,计算出 test 库中,以“GWGL_”开头的表名有多少个?
select count(*) from information_schema.TABLES where TABLE_SCHEMA='test' and
TABLE_NAME like 'GWGL_%';