检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
VALUES ('data') syntax contains 'data'. Query result returned from the database server, for example, the query result returned after the SELECT syntax is executed.
Table 3 SQL statements for defining a CMK Function SQL Statement Creating a CMK CREATE CLIENT MASTER KEY Dropping a CMK DROP CLIENT MASTER KEY Defining a Column Encryption Key (CEK) CEKs are used to encrypt data for the encrypted database feature.
Example: Parameters for Connecting to the Database in Different Scenarios In the following example, host:port represents a node, where host indicates the name or IP address of the server where the database resides, and port indicates the port number of the server where the database
CREATE TABLE gsloader_test_nullif( col1 varchar2(100) not null enable, col2 number(5,0) not null enable, col3 varchar2(200) not null enable, col4 varchar2(34) not null enable, col5 varchar2(750), col6 number(20,0), col7 varchar2(4000), col8 varchar2(200) ); // Data
For example, the INSERT...VALUES ('data') syntax contains 'data'. Query result returned from the database server, for example, the query result returned after the SELECT... syntax is executed.
For example, the INSERT...VALUES ('data') syntax contains 'data'. Query result returned from the database server, for example, the query result returned after the SELECT... syntax is executed.
Constraints This API is suitable only for nodes with CNs or DNs (primary or standby DNs). Debugging You can debug this API in API Explorer.
Constraints This API is suitable only for nodes with CNs or DNs (primary or standby DNs). Debugging You can debug this API in API Explorer.
The shard contains one primary DN, one standby DN, and one log-dedicated DN (also known as the log node). This model is only available for instances of V2.0-3.200 or later. This option is available only when Resource Type is set to Elastic Cloud Server (ECS).
If the standby node cannot be found, an exception is thrown. preferSlave: attempts to connect to a standby DN (if available) in the URL connection string.
Only letters (case-sensitive), digits, hyphens (-), and underscores (_) are allowed. Default Value N/A instance_id No String Definition Instance ID, which uniquely identifies an instance. Constraints N/A Range The value can contain 36 characters.
Range Global Transaction Manager (GTM): manages the status of transactions. Cluster Management Server (CMS): manages the instance status. Data node (DN): stores and queries table data.
Selecting a Storage Model [Recommendation] Selecting a storage model is the first step in defining a table. The storage model mainly depends on the customer's service type. For details, see Table 1.
If the standby node cannot be found, an exception is thrown. preferSlave: attempts to connect to a standby DN (if available) in the URL connection string.
CREATE TABLESPACE CREATE TABLE SUBPARTITION CREATE TRIGGER CREATE TYPE CREATE USER CREATE USER MAPPING CREATE VIEW CREATE WEAK PASSWORD DICTIONARY CURSOR DEALLOCATE DECLARE DELETE DO DROP AGGREGATE DROP AUDIT POLICY DROP CAST DROP CLIENT MASTER KEY DROP COLUMN ENCRYPTION KEY DROP
SCHEMA DROP SECURITY LABEL DROP SEQUENCE DROP SERVER DROP SLICEGROUP DROP SYNONYM DROP TABLE DROP TABLESPACE DROP TRIGGER DROP TYPE DROP USER DROP USER MAPPING DROP VIEW DROP WEAK PASSWORD DICTIONARY Parent topic: SQL Syntax
C CALL CHECKPOINT CLEAN CONNECTION CLOSE CLUSTER COMMENT COMMIT | END COMMIT PREPARED COPY CREATE AGGREGATE CREATE AUDIT POLICY CREATE CAST CREATE CLIENT MASTER KEY CREATE COLUMN ENCRYPTION KEY CREATE CONVERSION CREATE DATABASE CREATE DATABASE LINK CREATE DIRECTORY CREATE EVENT CREATE
Value range: enumerated values on (true, yes, 1): The primary node waits for the standby node to flush logs to disks before committing a transaction. off (false, no, 0): The primary node commits a transaction without waiting for the primary node to flush logs to disks.
Node group name (when enable_nodegroup_debug is set to on): A specific node group is used as the compute node group.
The shard contains one primary DN, one standby DN, and one log-dedicated DN (also known as the log node). This model is only available for instances of V2.0-3.200 or later. This option is available only when Resource Type is set to Elastic Cloud Server (ECS).
