select column_name,column_type,IF(column_key=‘PRI‘,1,0) AS ‘主键唯一‘,IF(IS_NULLABLE=‘NO‘,1,0) AS ‘非空‘,column_commentfrom information_schema.columns where table_name=‘saas_product_info‘;
Mysql 字典结构
原文:https://www.cnblogs.com/xushitairan/p/12133464.html