mysql 查询表字段说明

select
table_schema as '库名',table_name as '表名',column_name as '字段名',column_type as '字段类型',column_comment as '字段说明' ,
IS_NULLABLE '是否可为空' from information_schema.columns
where table_schema = 'cloudscape.hyc'
and table_name = 'smokevehicle' ; #你要查的表