查询数据库名:
select database()
查询表结构:
select * from INFORMATION_SCHEMA.TABLES where TABLE_NAME='表名' and table_schema = (select database())
查询数据库名:
select database()
查询表结构:
select * from INFORMATION_SCHEMA.TABLES where TABLE_NAME='表名' and table_schema = (select database())