Mysql 查询数据库所有以xx开头的表
SHOW TABLES FROM phpcms2 WHERE TABLES_IN_phpcms2 LIKE 'v9_%'
上面的例子是查询:模糊查找以v9_开头的所有表在phpcms2这个数据库内;
Dcr163的博客
http://dcr163.cn/175.html(转载时请注明本文出处及文章链接)
SHOW TABLES FROM phpcms2 WHERE TABLES_IN_phpcms2 LIKE 'v9_%'
上面的例子是查询:模糊查找以v9_开头的所有表在phpcms2这个数据库内;
Dcr163的博客
http://dcr163.cn/175.html(转载时请注明本文出处及文章链接)