MySQL Keywords and Features

Table 1 describes the MySQL keywords and features supported by DSC.

The Remarks column describes how to configure the migration of a keyword or feature.

**Table 1** MySQL keywords and features supported by DSC
Section	Object and Keyword/Feature		Version	Remarks
Basic Data Types	Numeric Types Date/Time Types String Types Spatial Data Types LOB Types Set Types Boolean Types Binary Types		8.0.1	Configured by setting •table.orientation •table.type •table.compress.mode •table.compress.row •table.compress.column •table.compress.level
MySQL Syntax Migration	Table Options	AUTO_INCREMENT AVG_ROW_LENGTH CHARSET CHECKSUM COLLATE COMMENT CONNECTION DELAY_KEY_WRITE DIRECTORY ENGINE INSERT_METHOD KEY_BLOCK_SIZE MAX_ROWS MIN_ROWS	8.0.1	-
	Tables Operation	LIKE (Table Cloning) ADD\|DROP COLUMN MODIFY (Column Modification) CHANGE (Column Modification) SET\|DROP COLUMN DEFAULT VALUE DROP (Table Deletion) TRUNCATE (Table Deletion) LOCK RENAME (Table Renaming)	8.0.1	-
	Indexes	Unique Indexes Normal and Prefix Indexes Hash Indexes B-tree Indexes Spatial Indexes Index Deletion	8.0.1	-
	Comments		8.0.1	-
	Databases		8.0.1	-
Data Manipulation Statements (DML)	INSERT	HIGH_PRIORITY LOW_PRIORITY PARTITION DELAYED VALUES ON DUPLICATE K...	8.0.1	-
	UPDATE	LOW_PRIORITY ORDER BY LIMIT IGNORE	8.0.1	-
	REPLACE	LOW_PRIORITY PARTITION DELAYED VALUES SET	8.0.1	-
Transaction Management and Database Management	Transaction Management	1 2	8.0.1	-
Transaction Management and Database Management	Database Management	1	8.0.1	-

Parent topic: Supported Keywords and Features

Did this article solve your problem?

Thank you for your score！Your feedback would help us improve the website.

Help Center