达梦数据库SQL语法

达梦数据库SQL语法
目录目录.....................................................1第1章结构化查询言语DM_SQL简介...........................121.1DM_SQL言语的特点.........................................121.2保留字与标识符............................................131.3DM_SQL言语的功能及语句....................................131.4DM_SQL所支持的数据类型....................................141.4.1常规数据类型........................................141.4.2位串数据类型........................................161.4.3日期时间数据类型.....................................171.4.4多媒体数据类型.......................................211.5DM_SQL言语支持的表达式....................................211.5.1数值表达式..........................................211.5.2字符串表达式........................................231.5.3时间值表达式........................................231.5.4时间间隔值表达式.....................................251.5.5运算符的优先级.......................................261.6DM_SQL言语支持的数据库模式................................27第2章手册中的示例说明....................................282.1示例库说明...............................................282.2参考脚本.................................................362.2.1创建示例库..........................................362.2.2创建模式及表........................................362.2.3插入数据............................................43第3章数据定义语句.......................................603.1数据库修改语句............................................603.2管理用户.................................................633.2.1用户定义语句........................................633.2.2修改用户语句........................................683.2.3用户删除语句........................................703.3管理模式.................................................713.3.1模式定义语句........................................713.3.2设置当前模式语句.....................................733.3.3模式删除语句........................................733.4管理表空间...............................................743.4.1表空间定义语句.......................................743.4.2修改表空间语句.