mysql下查询所有系统的数据库服务:
SELECT SCHEMA_NAME
FROM INFORMATION_SCHEMA.SCHEMATA
查询所有的表:
SELECT table_name, table_type, engine
FROM information_schema.tables
mysql下查询所有系统的数据库服务:
SELECT SCHEMA_NAME
FROM INFORMATION_SCHEMA.SCHEMATA
查询所有的表:
SELECT table_name, table_type, engine
FROM information_schema.tables