查询数据库下的所有表描述信息把where去掉
db是数据库名称
tablename是表名称
select * from information_schema.tables where table_schema = 'db' and table_name ='tablename'
查询表字段相关信息
SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'db' and TABLE_NAME='Users';
查询数据库下的所有表描述信息把where去掉
db是数据库名称
tablename是表名称
select * from information_schema.tables where table_schema = 'db' and table_name ='tablename'
查询表字段相关信息
SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'db' and TABLE_NAME='Users';