sql 2017-11-15

xiaoxiao2021-02-28  13

SELECT * FROM T_ALU_ALUMNI SELECT * FROM T_SYS_DICT WHERE CODE = 'NATIONALITY_TYPE'; SELECT * FROM T_SYS_DICT WHERE CODE = 'NATION_TYPE'; SELECT * FROM T_SYS_DICT WHERE CODE = 'EMPLOYMENT_STATUS_TYPE'; SELECT * FROM T_SYS_DICT WHERE CODE = 'POSITION_TYPE'; SELECT * FROM T_SYS_DICT WHERE CODE = 'ORG_ATTR_TYPE'; SELECT * FROM T_SYS_DICT WHERE CODE = 'ALU_TYPE'; SELECT * FROM T_SYS_DICT WHERE CODE = 'JXU'; SELECT * FROM T_SYS_DICT WHERE CODE = 'INDUSTRY_TYPE'; SELECT * FROM T_SYS_DICT WHERE NAME = '中国'; SELECT ID, TYPE, CODE, PID, NAME, SEQ, Remark from t_sys_dict where 1 = 1 AND (pid is null or pid = '') ORDER BY seq; SELECT * FROM T_SYS_DICT WHERE PID = 'af8cc8a8-f46a-4f9f-b118-7924356e573f'; INSERT INTO t_sys_dict(id,name,code,pid,seq,type) values('5f4f44ec-a90a-4f43-86c8-9ef6ec964a6c','阿鲁巴','ABW','af8cc8a8-f46a-4f9f-b118-7924356e573f',0,0);
转载请注明原文地址: https://www.6miu.com/read-1650321.html

最新回复(0)