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';

posted @ 2020-01-02 16:01  蓄势泰然  阅读(371)  评论(0编辑  收藏  举报