USE information_schema;
--获取表详细信息
select table_name,TABLE_SCHEMA,table_type,table_comment from TABLES
where TABLE_SCHEMA='ybtestdb'
-- 获取字段详细信息
select TABLE_NAME,TABLE_SCHEMA,COLUMN_NAME,COLUMN_COMMENT from COLUMNS
where TABLE_SCHEMA='ybestdb' and TABLE_NAME='myuser'