//查询表结构
select t.column_name,t.column_comment,t.column_type,case t.column_key when 'pri' then 'yes' else 'no' end,
t.is_nullable,t.column_comment from information_schema.'columns' t where t.table_name = '表名'
//查询表结构
select t.column_name,t.column_comment,t.column_type,case t.column_key when 'pri' then 'yes' else 'no' end,
t.is_nullable,t.column_comment from information_schema.'columns' t where t.table_name = '表名'