比如,计算出 test 库中,以“GWGL_”开头的表名有多少个?
select count(*) from information_schema.TABLES where TABLE_SCHEMA='test' and
TABLE_NAME like 'GWGL_%';
转载于:https://blog.51cto.com/13504089/2052533
比如,计算出 test 库中,以“GWGL_”开头的表名有多少个?
select count(*) from information_schema.TABLES where TABLE_SCHEMA='test' and
TABLE_NAME like 'GWGL_%';
转载于:https://blog.51cto.com/13504089/2052533