常见达梦数据库操作

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15

select
distinct
utc.COLUMN_ID 排序,
ucc.comments as 中文名,
utc.column_name as 字段名,
concat(utc.data_type,'(',utc.data_length, ')') as 类型,
'否' as 主键,
'否' as 外键,
'' as 备注
from user_tab_columns utc,user_col_comments ucc
where utc.column_name = ucc.column_name and utc.Table_Name = ucc.Table_Name

AND utc.TABLE_NAME='PORTAL_FUNCTIONAL_PERMISSIONS' -- 表明
AND ucc.owner='PORTAL'  -- 模式SCHEMA名
order by utc.COLUMN_ID

1
2
3
4
5
6
7

-- 1. 时间格式化 时间戳-》YYYY-MM-DD形式
FROM_UNIXTIME(create_time/1000,'YYYY-MM-DD hh:mm:ss')

-- 2. json类型字段查询
JSON_VALUE(jsonparam, '$.key') -- value为非数组情况
JSON_VALUE(jsonparam, '$.key[0]') -- value为数组的情况下
select lower(rawtohex(sys_guid())) -- id生成