GBase-Up统一数据平台SQL技术手册-D.docx

GBase UP 统一数据平台 SQL 目 录 HYPERLINK \l "_bookmark0" 前言 1 HYPERLINK \l "_bookmark1" 手册简介 1 HYPERLINK \l "_bookmark2" 公约 2 HYPERLINK \l "_bookmark3" 数据类型 3 HYPERLINK \l "_bookmark4" 数值类型 3 HYPERLINK \l "_bookmark5" TINYINT 4 HYPERLINK \l "_bookmark6" SMALLINT 4 HYPERLINK \l "_bookmark7" INT 4 HYPERLINK \l "_bookmark8" BIGINT 4 HYPERLINK \l "_bookmark9" FLOAT 5 HYPERLINK \l "_bookmark10" DOUBLE 7 HYPERLINK \l "_bookmark11" DECIMAL 8 HYPERLINK \l "_bookmark12" 字符类型 10 HYPERLINK \l "_bookmark13" CHAR 10 HYPERLINK \l "_bookmark14" VARCHAR 11 HYPERLINK \l "_bookmark15" TEXT 12 HYPERLINK \l "_bookmark16" 二进制数据类型 12 HYPERLINK \l "_bookmark17" 日期和时间类型 13 HYPERLINK \l "_bookmark18" DATE 13 HYPERLINK \l "_bookmark19" TIME 14 HYPERLINK \l "_bookmark20" DATETIME 16 HYPERLINK \l "_bookmark21" TIMESTAMP 17 HYPERLINK \l "_bookmark22" SQL语言基础 20 HYPERLINK \l "_bookmark23" 2.1 数值 20 HYPERLINK \l "_bookmark24" 2.1.1 字符串 20 HYPERLINK \l "_bookmark25" 2.1.2 数字 23 HYPERLINK \l "_bookmark26" 十六进制值 23 HYPERLINK \l "_bookmark27" 布尔值 25 HYPERLINK \l "_bookmark28" NULL值 25 HYPERLINK \l "_bookmark29" 数据库、表、列和别名 25 HYPERLINK \l "_bookmark30" 标识符限定词 26 HYPERLINK \l "_bookmark31" 注释语法 27 HYPERLINK \l "_bookmark32" 用户变量 29 HYPERLINK \l "_bookmark33" 操作符和函数 30 HYPERLINK \l "_bookmark34" 操作符 30 HYPERLINK \l "_bookmark35" 操作符优先级 30 HYPERLINK \l "_bookmark36" 圆括号 31 HYPERLINK \l "_bookmark37" 比较函数和操作符 32 HYPERLINK \l "_bookmark39" 逻辑操作符 46 HYPERLINK \l "_bookmark40" 转换操作符和函数 50 HYPERLINK \l "_bookmark41" 控制流函数 53 HYPERLINK \l "_bookmark42" CASE 53 HYPERLINK \l "_bookmark43" DECODE 55 HYPERLINK \l "_bookmark44" IF(expr1,expr2,expr3) 55 HYPERLINK \l "_bookmark45" IFNULL(expr1,expr2) 57 HYPERLINK \l "_bookmark46" NULLIF(expr1,expr2) 57 HYPERLINK \l "_bookmark47" 字符串函数 58 HYPERLINK \l "_bookmark48" ASCII(str) 58 HYPERLINK \l "_bookmark49" 3.3.2 BIN(N) 59 HYPERLINK \l "_bookmark50" 3.3.3 BIT_LENGTH(str) 59 HYPERLINK \l "_bookmark51" 3.3.4 CHAR(N,...) 60 HYP