- 计算
- 网络
- 存储与CDN
-
数据库
-
云数据库 RDS MySQL
- 产品概述
- 产品定价
- 快速入门
- 操作手册
- 案例实践
- API文档
-
常见问题
- 如何访问MySQL实例?
- MySQL实例的安全性如何?
- 如何向MySQL实例中导入数据?
- 如何向MySQL实例中导出数据?
- 如何创建新用户并授予权限?
- QPS是如何统计的?
- 什么是内存溢出?
- 默认的最大连接数是多少?
- 如何查看数据库运行状态?
- 如何查看MySQL实例的SlowLog?
- 如何修改MySQL实例的配置参数?
- 如何安装和卸载插件?
- 如何使用MySQL-Proxy使MySQL实例可以通过外网访问?
- 何查看MySQL实例的各项监控指标?
- 是否可以查看云数据库运行状态?
- 默认的配置是针对哪种存储引擎优化的?
- 如何在云主机上搭建云数据库从库并进行主从同步呢?
- 如何正确设置字符集?
- 如何查询MySQL实例的客户端和服务器端版本
- 相关协议
- 云数据库 RDS PostgreSQL
- 云数据库 Redis
- 云数据库 MongoDB
- 分布式数据库 InDDB
- 云数据库 Memcache
-
云数据库 RDS MySQL
- 安全
- 人工智能
-
大数据
- ES服务 Elasticsearch
- 数据仓库 DW
- 托管Hadoop
- 管理和监控
-
API
-
对象存储OSS
- 创建Bucket-CreateBucket
- 获取Bucket信息-DescribeBucket
- 更改Bucket属性-UpdateBucket
- 删除Bucket-DeleteBucket
- 前缀列表查询 – PrefixFileList
- 上传文件 – PutFile
- 表单上传 – PostFile
- 秒传文件-UploadHit
- 下载文件-GetFile
- 查询文件基本信息-HEADFile
- 删除文件 – DeleteFile
- 初始化分片 – InitiateMultipartUpload
- 上传分片 – UploadPart
- 完成分片 – FinishMultipartUpload
- 放弃分片 – AbortMultipartUpload
- 查看配额状态-GetUFileQuota
- 查询配额支付价格-GetUFileQuotaPrice
- 查看配额使用报表-GetUFileReport
- 获取配额信息-GetUFileQuotaInfo
- 获取已上传成功的分片列表-GetMultiUploadPart
- 更新令牌-UpdateUFileToken
- 删除令牌-DeleteUFileToken
- 获取令牌信息-DescribeUFileToken
- OSS 错误码列表
- 操作文件的Meta信息 – OpMeta
- API文档综述
-
弹性公网IP EIP
- 1、申请弹性IP-AllocateEIP
- 2、获取弹性IP信息-DescribeEIP
- 3、更新弹性IP属性-UpdateEIPAttribute
- 4、释放弹性IP-ReleaseEIP
- 5、绑定弹性IP-BindEIP
- 6、解绑弹性IP-UnBindEIP
- 7、调整弹性IP带宽-ModifyEIPBandwidth
- 8. 修改弹性IP出口权重-ModifyEIPWeight
- 9. 获取弹性IP价格-GetEIPPrice
- 10. 获取弹性IP带宽改动价格-GetEIPUpgradePrice
- 11. 获取弹性IP计费方式-GetEIPPayMode
- 12. 设置弹性IP计费方式-SetEIPPayMode
- 13. 申请内网虚拟IP-AllocateVIP
- 14. 获取内网虚拟IP信息-DescribeVIP
- 15. 释放内网虚拟IP- ReleaseVIP
- 16. 创建带宽包-CreateBandwidthPackage
- 17. 获取带宽包信息-DescribeBandwidthPackage
- 18. 删除带宽包-DeleteBandwidthPackage
- 19. 开通共享带宽-AllocateShareBandwidth
- 20. 获取共享带宽信息-DescribeShareBandwidth
- 21. 调整共享带宽-ResizeShareBandwidth
- 22. 关闭共享带宽-ReleaseShareBandwidth
- 23. 将EIP加入共享带宽-AssociateEIPWithShareBandwidth
- 24. 将EIP移出共享带宽-DisassociateEIPWithShareBandwidth
- 25. 获取带宽用量-DescribeBandwidthUsage
- 26. 更新防火墙属性-UpdateFirewallAttribute
- 27. 获取防火墙信息-DescribeFirewall
- 28. 应用防火墙-GrantFirewall
- 29. 错误码
-
云服务器ECS
- 1、获取VNC登录信息-GetUHostInstanceVncInfo
- 2、启动云服务器-StartUHostInstance
- 3、重启云服务器-RebootUHostInstance
- 4、关闭云服务器-StopUHostInstance
- 5、获取云服务器业务组列表-DescribeUHostTags
- 6、字段规范
- 7、删除云服务器-TerminateUHostInstance
- 8、重置云服务器密码-ResetUHostInstancePassword
- 9、修改云服务器业务组-ModifyUHostInstanceTag
- 10、修改云服务器名-ModifyUHostInstanceName
- 11、获取挂载磁盘的升级价格-GetAttachedDiskUpgradePrice
- 12、修改云服务器配置-ResizeUHostInstance
- 13、获取升级配置价格-GetUHostUpgradePrice
- 14、创建云服务器-CreateUHostInstance
- 15、移除硬件隔离组-LeaveIsolationGroup
- 16、创建硬件隔离组-CreateIsolationGroup
- 17、删除自制镜像-TerminateCustomImage
- 18、创建自制镜像-CreateCustomImage
- 19、导入镜像-ImportCustomImage
- 20、修改云服务器备注-ModifyUHostInstanceRemark
- 21、修改挂载的磁盘大小-ResizeAttachedDisk
- 22、模拟服务器掉电-PoweroffUHostInstance
- 23、重装系统-ReinstallUHostInstance
- 24、获取镜像列表-DescribeImage
- 25、获取云服务器价格-GetUHostInstancePrice
- 26、获取云服务器信息-DescribeUHostInstance
- 27、普通机型开启CDP-UpgradeToArkUHostInstance
-
对象存储OSS
- 用户提醒
- 服务等级协议(SLA)
- 企业上云常见问题
- 其他协议
- 云市场
- 开发者
- 账户管理
-
● 命令:ABORT
描述: 终止当前事务
语法:
ABORT [ WORK | TRANSACTION ] ● 命令: ALTER AGGREGATE
描述: 改变一个聚集函数的定义
语法:
ALTER AGGREGATE 名字 ( 类型 ) RENAME TO 新名字 ● 命令: ALTER DATABASE
描述: 改变一个数据库
语法:
ALTER DATABASE 名字 SET 参数 { TO | = } { 值 | DEFAULT }
ALTER DATABASE 名字 RESET 参数
ALTER DATABASE 名字 RENAME TO 新名字
ALTER DATABASE 名字 OWNER TO 新属主
● 命令: ALTER FUNCTION
描述: 改变一个函数的定义
语法:
ALTER FUNCTION 名字 ( [ 类型 [, ...] ] ) RENAME TO 新名字
ALTER FUNCTION 名字 ( [ 类型 [, ...] ] ) OWNER TO 新属
● 命令: ALTER GROUP
描述: 改变一个用户组
语法:
ALTER GROUP 组名称 ADD USER 用户名称 [, ... ]
ALTER GROUP 组名称 DROP USER 用户名称 [, ... ]
ALTER GROUP 组名称 RENAME TO 新名称
● 命令: ALTER INDEX
描述: 改变一个索引的定义
语法:
ALTER INDEX name RENAME TO new_name
ALTER INDEX name SET TABLESPACE tablespace_name
ALTER INDEX name SET (storage_parameter = value )
ALTER INDEX name RESET (storage_parameter [, ... ])
● 命令: ALTER SCHEMA
描述: 改变一个模式的定义
语法:
ALTER SCHEMA 名字 RENAME TO 新名字
ALTER SCHEMA 名字 OWNER TO 新属主
● 命令: ALTER SEQUENCE
描述: 改变一个序列生成器的定义
语法:
ALTER SEQUENCE 名字 [ INCREMENT [ BY ] 递增 ] [ MINVALUE 最小值 | NO
MINVALUE ] [ MAXVALUE 最大值 | NO MAXVALUE ] [ RESTART [ WITH ] 开始 ]
[ CACHE 缓存 ] [ [ NO ] CYCLE ] [OWNED BY {表名.列名 | NONE}] ALTER
SEQUENCE name SET SCHEMA new_schema
● 命令: ALTER TYPE
描述: 改变一个类型的定义语法:
ALTER TYPE 名字 OWNER TO 新属主 ● 命令: ALTER USER
描述: 改变一个数据库用户
语法:
ALTER USER name RENAME TO newname
ALTER USER name SET parameter { TO | = } { value | DEFAULT }
ALTER USER name RESET parameter
ALTER USER name [ [ WITH ] option [ ... ] ] where option can
be: CREATEDB | NOCREATEDB
● 命令: ANALYZE
描述: 收集关于数据库的统计信息
语法:
ANALYZE [VERBOSE] [ROOTPARTITION [ALL] ] [table [ (column [, ...] ) ]] ● 命令: BEGIN
描述: 开始一个事务块
语法:
BEGIN [ WORK | TRANSACTION ] [ 事务模式] [ READ WRITE | READ ONLY ]事务模式为下面之一:ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED | READ UNCOMMITTED }● 命令: CLOSE
描述: 关闭一个游标
语法: CLOSE 名字
● 命令: COMMIT
描述: 提交当前事务
语法: COMMIT [ WORK | TRANSACTION ]
● 命令: COPY
描述: 在一个文件和一个表之间拷贝数据
语法:
COPY table [(column [, ...])] FROM {'file' | STDIN} [ [WITH] [OIDS]
[HEADER] [DELIMITER [ AS ] 'delimiter'] [NULL [ AS ] 'null string'] [ESCAPE
[ AS ] 'escape' | 'OFF'] [NEWLINE [ AS ] 'LF' | 'CR' | 'CRLF'] [CSV [QUOTE
[ AS ] 'quote'] [FORCE NOT NULL column [, ...]] [FILL MISSING FIELDS] [[LOG
ERRORS [INTO error_table] [KEEP] SEGMENT REJECT LIMIT count [ROWS |
PERCENT] ] COPY {table [(column [, ...])] | (query)} TO {'file' | STDOUT}
[ [WITH] [OIDS] [HEADER] [DELIMITER [ AS ] 'delimiter'] [NULL [ AS ] 'null
string'] [ESCAPE [ AS ] 'escape' | 'OFF'] [CSV [QUOTE [ AS ] 'quote']
[FORCE QUOTE column [, ...]] ] [IGNORE EXTERNAL PARTITIONS ]
● 命令: CREATE AGGREGATE
描述: 定义一个新的聚集函数
语法:
CREATE [ORDERED] AGGREGATE name (input_data_type [ , ... ]) ( SFUNC =
sfunc, STYPE = state_data_type [, PREFUNC = prefunc] [, FINALFUNC = ffunc]
[, INITCOND = initial_condition] [, SORTOP = sort_operator] )
● 命令: CREATE CAST
描述: 定义一个新的类型转换
语法:
CREATE CAST (源类型 AS 目标类型) WITH FUNCTION 函数名 (参数类型) [ AS
ASSIGNMENT | AS IMPLICIT ] CREATE CAST (源类型 AS 目标类型) WITHOUT
FUNCTION [ AS ASSIGNMENT | AS IMPLICIT ]
● 命令: CREATE DATABASE
描述: 创建一个新的数据库
语法:
CREATE DATABASE 数据库名称 [ [ WITH ] [ OWNER [=] 数据库属
主 ] [ TEMPLATE [=] 模板 ] [ ENCODING [=] 编码 ] [ TABLESPACE [=] 表
空间 ] ]
● 命令: CREATE FUNCTION
描述: 定义一个新的函数
语法:
CREATE [ OR REPLACE ] FUNCTION 名字 ( [ [ 参数名字 ] 参数类型
[, ...] ] ) RETURNS 返回类型 { LANGUAGE 语言名称 | IMMUTABLE | STABLE |
VOLATILE | CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT |
STRICT | [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY
DEFINER | AS 'definition' | AS 'obj_file', 'link_symbol' } … [ WITH
( attribute [, ...] ) ]
● 命令: CREATE GROUP
描述: 定义一个新的用户组
语法:
CREATE GROUP 组名 [ [ WITH ] option [ ... ] ] option 可以为: SUPERUSER |
NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE |
CREATEUSER | NOCREATEUSER | INHERIT | NOINHERIT | LOGIN | NOLOGIN |
[ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password' | VALID UNTIL 'timestamp' |
IN ROLE rolename [, ...] | IN GROUP rolename [, ...] | ROLE rolename
[, ...] | ADMIN rolename [, ...] | USER rolename [, ...] | SYSID uid
● 命令: CREATE INDEX
描述: 定义一个新的索引
语法:
CREATE [ OR REPLACE ] RULE 名字 AS ON 事件 TO 表 [ WHERE 条件 ] DO
[ ALSO | INSTEAD ] { NOTHING | 命令 | ( 命令 ; 命令 ... ) }
● 命令: CREATE SCHEMA
描述: 定义一个新的模式
语法:
CREATE SCHEMA 模式名称 [ AUTHORIZATION 用户名称 ] [ 模式元素 [ ... ] ]
CREATE SCHEMA AUTHORIZATION 用户名称 [ 模式元素 [ ... ] ]
● 命令: CREATE SEQUENCE
描述: 定义一个新的序列生成器
语法:
CREATE [ TEMPORARY | TEMP ] SEQUENCE name [ INCREMENT
[ BY ] increment ] [ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE
maxvalue | NO MAXVALUE ] [ START [ WITH ] start ] [ CACHE cache ] [ [ NO ]
CYCLE ] [OWNED BY { table.column | NONE }]
● 命令: CREATE TABLE
描述: 定义一个新的表
语法:
CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name
( { column_name data_type [ DEFAULT default_expr ] [ column_constraint
[ ... ] ] | table_constraint | LIKE parent_table [ { INCLUDING |
EXCLUDING } DEFAULTS ] } [, ... ] ) [ INHERITS ( parent_table
[, ... ] ) ] [ WITH OIDS | WITHOUT OIDS ] [ ON COMMIT { PRESERVE ROWS |
DELETE ROWS | DROP } ] [ TABLESPACE tablespace ] where column_constraint
is: [ CONSTRAINT constraint_name ] { NOT NULL | NULL | UNIQUE [ USING
INDEX TABLESPACE tablespace ] | PRIMARY KEY [ USING INDEX TABLESPACE tablespace
] | CHECK (expression) | REFERENCES reftable [ ( refcolumn ) ]
[ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE action ] [ ON
UPDATE action ] } [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED |
INITIALLY IMMEDIATE ] and table_constraint is: [ CONSTRAINT
constraint_name ] { UNIQUE ( column_name [, ... ] ) [ USING INDEX
TABLESPACE tablespace ] | PRIMARY KEY ( column_name [, ... ] ) [ USING
INDEX TABLESPACE tablespace ] | CHECK ( expression ) | FOREIGN KEY
( column_name [, ... ] ) REFERENCES reftable [ ( refcolumn
[, ... ] ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE
action ] [ ON UPDATE action ] } [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY
DEFERRED | INITIALLY IMMEDIATE ]
● 命令: CREATE TABLE AS
描述: 以一个查询的结果定义一个新的表
语法:
CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE 表名字 [ (字段名字
[, ...] ) ] [ [ WITH | WITHOUT ] OIDS ] AS query
● 命令: CREATE TYPE
描述: 定义一个新的数据类型
语法:
CREATE TYPE name AS ( attribute_name data_type [, ... ] ) CREATE TYPE name
( INPUT = input_function, OUTPUT = output_function [, RECEIVE =
receive_function] [, SEND = send_function] [, INTERNALLENGTH =
{internallength | VARIABLE}] [, PASSEDBYVALUE] [, ALIGNMENT = alignment] [,
STORAGE = storage] [, DEFAULT = default] [, ELEMENT = element] [, DELIMITER
= delimiter] ) CREATE TYPE name
● 命令: CREATE USER
描述: 定义一个新的数据库用户帐户
语法:
CREATE USER name [ [ WITH ] option [ ... ] ] where option can
be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE |
NOCREATEROLE | CREATEUSER | NOCREATEUSER | INHERIT | NOINHERIT | LOGIN |
NOLOGIN | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password' | VALID UNTIL
'timestamp' | IN ROLE rolename [, ...] | IN GROUP rolename [, ...] | ROLE
rolename [, ...] | ADMIN rolename [, ...] | USER rolename [, ...] | SYSID
uid | RESOURCE QUEUE queue_name
命令: CREATE VIEW 描述: 定义一个新的视图 语法:
CREATE [OR REPLACE] [TEMP | TEMPORARY] VIEW name [ ( column_name
[, ...] ) ] AS query
● 命令: DECLARE
描述: 定义一个游标
语法:
DECLARE name [BINARY] [INSENSITIVE] [NO SCROLL] CURSOR [{WITH | WITHOUT}
HOLD] FOR query [FOR READ ONLY]
● 命令: DELETE
描述: 删除一个表的记录
语法:
DELETE FROM [ ONLY ] 表 [ WHERE 条件] ● 命令: DROP AGGREGATE
描述: 删除一个聚集函数
语法:
DROP AGGREGATE 名字 ( 类型 ) [ CASCADE | RESTRICT ] ● 命令: DROP CAST