检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
CREATE FOREIGN DATA WRAPPER CREATE FOREIGN TABLE CREATE FUNCTION CREATE GLOBAL INDEX CREATE GROUP CREATE INCREMENTAL MATERIALIZED VIEW CREATE INDEX CREATE LANGUAGE CREATE MASKING POLICY CREATE MATERIALIZED VIEW CREATE MODEL CREATE NODE CREATE NODE GROUP CREATE PACKAGE CREATE PROCEDURE
CREATE TABLE myschema.mytable (firstcol int); Insert data into the table. INSERT INTO myschema.mytable values (100); View data in the table. SELECT * FROM myschema.mytable; | firstcol | ---+----------+ 1 | 100 | Update data in the table.
DROP LANGUAGE DROP MASKING POLICY DROP MATERIALIZED VIEW DROP MODEL DROP NODE DROP NODE GROUP DROP OWNED DROP PACKAGE DROP PROCEDURE DROP RESOURCE LABEL DROP RESOURCE POOL DROP ROLE DROP ROW LEVEL SECURITY POLICY DROP SCHEMA DROP SECURITY LABEL DROP SEQUENCE DROP SERVER DROP SLICEGROUP
For example, FIRST 1 (dn_instanceId1, dn_instanceId2) indicates that dn_instanceId1 is selected as the standby node for synchronous replication. The meanings of dn_instanceId1, dn_instanceId2, ... are the same as those of FIRST 1 (dn_instanceId1, dn_instanceId2, ...).
The value can be configured in the following format: ANY num_sync (standby_name [, ...]) [FIRST] num_sync (standby_name [, ...]) standby_name [, ...]
The value can be configured in the following format: ANY num_sync (standby_name [, ...]) [, ANY num_sync (standby_name [, ...])]
The value can be configured in the following format: ANY num_sync (standby_name [, ...]) [, ANY num_sync (standby_name [, ...])] [FIRST] num_sync (standby_name [, ...]) standby_name [, ...]
Best Practices of Table Design Selecting a Storage Model Selecting a Distribution Mode Selecting Distribution Keys Using Partitioned Tables Selecting a Data Type Checking a Node Where a Table Resides Parent topic: Best Practices
Only letters, digits, hyphens (-), and underscores (_) are allowed. role String Explanation: Node type, indicating the role of a node in an instance.
Table 11 nodes Parameter Type Description id String Node ID. name String Node name. role String Node type. master: primary node slave: standby node secondary: log node readreplica: read replica. status String Node status.
Only letters, digits, hyphens (-), and underscores (_) are allowed. role String Explanation: Node type, indicating the role of a node in an instance. Value: master (primary node) or slave (standby node) status String Explanation: Node status.
This port is enabled on the Kunpeng 4-socket server and disabled on the Kunpeng 2-socket server through output parameter control.
(rsmd.getColumnLabel(i) + " " + rsmd.getColumnName(i)); } Parent topic: Typical Application Development Examples
(rsmd.getColumnLabel(i) + " " + rsmd.getColumnName(i)); } Parent topic: Typical Application Development Examples
(rsmd.getColumnLabel(i) + " " + rsmd.getColumnName(i)); } Application Lossless Transparent (ALT) Planned ALT During planned maintenance (such as restarting database instances, performing a switchover, restarting nodes, and restarting DNs), JDBC and DNs are disconnected.
Table 3 SQL statements for defining a CMK Function SQL Statement Creating a CMK CREATE CLIENT MASTER KEY Deleting a CMK DROP CLIENT MASTER KEY Defining a Column Encryption Key (CEK) CEKs are used to encrypt data for the encrypted database feature.
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.
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.
VALUES ('data') syntax contains 'data'. Query result returned from the database server, for example, the query result returned after the SELECT syntax is executed.
POLICY DROP CLIENT MASTER KEY DROP COLUMN ENCRYPTION KEY DROP DATABASE DROP DATABASE LINK DROP DIRECTORY DROP FOREIGN DATA WRAPPER DROP FUNCTION DROP GLOBAL CONFIGURATION DROP GROUP DROP INDEX DROP LANGUAGE DROP MASKING POLICY DROP MATERIALIZED VIEW DROP MODEL DROP NODE DROP NODE