查询指定前缀的所有表名,并用逗号分隔
SELECT GROUP_CONCAT(TABLE_NAME) FROM information_schema.tables WHERE TABLE_NAME LIKE '%tablename_%';
查询指定前缀的所有表名,并用逗号分隔
SELECT GROUP_CONCAT(TABLE_NAME) FROM information_schema.tables WHERE TABLE_NAME LIKE '%tablename_%';