mysql查询指定表的字段信息

方法一：show full columns from res_store_place;

这种方法会将所有表的表字段信息列出来。

方法二：

 

select t.TABLE_SCHEMA as '表空间' ,t.TABLE_NAME as '表名' , t.COLUMN_KEY as '是否主键' ,t.COLUMN_NAME as '字段名称' , t.IS_NULLABLE as '是否可为空' ,

t.column_type as '类型' ,t.COLUMN_COMMENT as '注释'

from information_schema.columns t where table_schema in ('sinochem_order_goods','sinochem_order_info','sinochem_order_member','sinochem_order_order');