sql 2017-11-15

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