Mysql 字典结构
select
column_name,
column_type,
IF(column_key='PRI',1,0) AS '主键唯一',
IF(IS_NULLABLE='NO',1,0) AS '非空',
column_comment
from information_schema.columns
where
table_name='saas_product_info';
select
column_name,
column_type,
IF(column_key='PRI',1,0) AS '主键唯一',
IF(IS_NULLABLE='NO',1,0) AS '非空',
column_comment
from information_schema.columns
where
table_name='saas_product_info';