01 2020 档案
摘要：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
阅读全文
摘要：SELECT[表名]=case when a.colorder=1 then d.name else '' end,[表说明]=case when a.colorder=1 then isnull(f.value,'') else '' end,[字段名]=a.name,[主键]=case when
阅读全文
