SQL
java后生
相互学习,共同进步!
展开
-
SQL导出 表设计文档
SELECT ‘表名’ 表名, ‘表中文名称’ 表中文名称, COLUMN_NAME 字段名称, COLUMN_TYPE 字段类型, COLUMN_DEFAULT 默认值, CHARACTER_MAXIMUM_LENGTH AS 最大长度, ( CASE WHEN is_nullable = ‘NO’ THEN ‘否’ ELSE ‘是’ END ) AS 是否可空, ( CASE WHEN column_key = ‘PRI’ THEN ‘是’ ELSE ‘否’ END ) AS 是否主键, COLUMN_原创 2022-01-06 15:48:51 · 554 阅读 · 0 评论 -
单表自关联显示parentName
SELECT a.* , CASE WHEN a.parent_id != ‘0’ THEN ( SELECT name FROM sys_menu WHERE id = a.parent_id ) ELSE 0 END AS ‘parentName’ FROM sys_menu a ORDER BY a.sort ASC原创 2021-07-09 14:10:05 · 145 阅读 · 0 评论