不知道数据库的情况下:
select * from information_schema.TABLES where TABLE_SCHEMA=(select database()) and table_name ='表名'
如果知道数据库名也可以这样:
select * from information_schema.TABLES where TABLE_SCHEMA='数据库名' and table_name ='your table'
不知道数据库的情况下:
select * from information_schema.TABLES where TABLE_SCHEMA=(select database()) and table_name ='表名'
如果知道数据库名也可以这样:
select * from information_schema.TABLES where TABLE_SCHEMA='数据库名' and table_name ='your table'