MySQL-compatible Kernel Description
Table 1 MySQL-compatible features implemented in the openGauss kernel
CREATE DATABASE | ||
CREATE SCHEMA | ||
ALTER USER | ||
ALTER VIEW | ||
CREATE VIEW | ||
DDL | The COMMENT option can be specified in the statements for creating and modifying objects. | ALTER FUNCTION, ALTER PROCEDURE, ALTER TABLE, CREATE FUNCTION, CREATE INDEX, CREATE PROCEDURE, CREATE TABLE, CREATE TABLE PARTITION, and CREATE TABLE SUBPARTITION |
CREATE TABLE supports the creation of primary keys, UNIQUE indexes, and foreign key constraints. | CREATE TABLE | |
ALTER TABLE supports the creation of primary keys, UNIQUE indexes, and foreign key constraints. | ALTER TABLE | |
CREATE TABLE supports the creation of auto-increment columns. | CREATE TABLE | |
DELETE | ||
DELETE | ||
DELETE supports the deletion of data from a specified partition or subpartition. | DELETE | |
The | UPDATE | |
The | UPDATE | |
SET | ||
SET | ||
Character Types | ||
SET Type | ||
Simple Expressions | ||
Aggregate Functions | ||
The security functions aes_decrypt and aes_encrypt are supported. | Security Functions | |
The character processing functions SHA, SHA1, and SHA2 are supported. | Character Processing Functions and Operators |
Feedback