sql 2017-11-15
来源:互联网 发布:淘宝买机票 编辑:程序博客网 时间:2024/06/03 14:29
SELECT * FROM T_ALU_ALUMNISELECT * 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);
阅读全文
0 0
- sql 2017-11-15
- 2017-11-08-UPDATE-BY-ZengWenFeng.sql
- sql-2017-11-09 group by cnt
- 2017-11-30-UPDATE-BY-ZengWenFeng.sql
- SQL 2017 & Azure SQL 新功能:图形数据库
- [SQL][2012-11-29] sql using 语句
- SQL 基础 总结(11) SQL语句
- Sql练习15题
- 2017/4/13 SQL
- sql 2017-10-27
- 11-sql语句
- PL/SQL 11 注册码
- SQL
- SQL
- SQL
- sql
- sql
- SQL
- groovy 循环List<Map<String, Object>>
- HTML5 新元素 总结
- 桥美信息-学习笔记02
- 94. Binary Tree Inorder Traversal
- JDBC连接数据库mysql
- sql 2017-11-15
- 鼠标悬停,图片向四周放大效果
- 九九乘法表
- 零基础学iOS系列之swift语法基础
- 手把手教你用0行代码实现人脸检测
- 文章标题
- [学习笔记][Java编程思想]第3章:操作符
- 2017-11-15 深刻理解堆栈及PUSH POP指令
- php实现进度条