Kingwow 分布式数据库 SQL 使用手册
上海丛云信息科技有限公司 [2]
目录
1. 编写目的 .......................................................................................................................................................5
2. 读者对象 .......................................................................................................................................................5
3. 基本的数据库对象 .....................................................................................................................................5
4. SQL 基础 ......................................................................................................................................................5
4.1. 数据类型 ............................................................................................................................ 6
4.2. 函数 ...................................................................................................................................... 7
4.2.1. 系统函数 ............................................................................................................................ 7
4.2.2. 聚集函数 .......................................................................................................................... 17
4.3. 运算符 ............................................................................................................................... 19
4.4. 转义字符 .......................................................................................................................... 21
5. SQL 语法 ................................................................................................................................................... 21
5.1. 数据定义语句 ................................................................................................................. 21
5.1.1. CREATE DATABASE ................................................................................................ 21
5.1.2. DROP DATABASE ...................................................................................................... 22
5.1.3. CREATE TABLE .......................................................................................................... 22
5.1.4. ALTER TABLE .............................................................................................................. 24
5.1.5. DROP TABLE ................................................................................................................ 25
5.1.6. CREATE VIEW ............................................................................................................. 25
5.1.7. CREATE INDEX ........................................................................................................... 26
5.1.8. DROP INDEX ................................................................................................................ 27
5.1.9. TRUNCATE TABLE .................................................................................................... 27
5.1.10. CREATE SEQUENCE ...................................................................................... 28
5.1.11. ALTER SEQUENCE .......................................................................................... 30
5.1.12. DROP SEQUENCE ............................................................................................ 31
5.2. 数据操作语句 ................................................................................................................. 31
5.2.1. INSERT ............................................................................................................................ 31
5.2.2. REPLACE ....................................................................................................................... 32
5.2.3. UPDATE .......................................................................................................................... 33
5.2.4. DELETE ........................................................................................................................... 33
5.2.5. SELECT ........................................................................................................................... 34
评论