Help Center/ GaussDB(DWS)/ Tool Guide/ DSC/ MySQL Syntax Migrating/ Supported Keywords and Features

Updated on 2024-12-09 GMT+08:00

View PDF

Supported Keywords and Features

Table 1 lists the MySQL keywords and features that can be migrated.

The Version column contains the earliest versions that support the keywords or features.

The Remarks column contains the configuration parameters to customize how the migration tool migrates the corresponding keywords or features.

**Table 1**
Section	Object->Keyword/Feature		Version	Remarks
Data Types	Numeric Types		8.0.0	You can specify the month when the coupon will expire. table.orientation table.type table.compress.mode table.compress.row table.compress.column table.compress.level
	Date/Time Types		8.0.0
	String Types		8.0.0
	Spatial Data Types		8.0.0
	LOB Types		8.0.0
	Set Types		8.0.0
	Boolean		8.0.0
	Binary Types		8.0.0
	JSON		8.0.0
Functions and Expressions	Type Mapping		8.0.0	-
Table (Optional Parameters and Operations)	Table (Optional Parameters and Operations)	AUTO_INCREMENT AVG_ROW_LENGTH CHARSET CHECKSUM COLLATE COMMENT CONNECTION DELAY_KEY_WRITE DIRECTORY ENGINE KEY_BLOCK_SIZE INSERT_METHOD MAX_ROWS MIN_ROWS PACK_KEYS PASSWORD ROW_FORMAT STATS_AUTO_RECALC STATS_PERSISTENT STATS_SAMPLE_PAGES UNION LIKE Table Cloning Adding and Deleting a Column MODIFY: Modifying a Column CHANGE: Changing a Column SET\|DROP COLUMN DEFAULT VALUE DROP (Table Deletion) TRUNCATE (Table Deletion) LOCK RENAME (Table Renaming)	8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0	-
	Table (Optional Parameters and Operations)			-
	Indexes	Unique Indexes Normal and Prefix Indexes Hash index B-tree Indexes Spatial Indexes Full-Text Indexes Deleting an Index Renaming an Index	8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0	-
	Comment		8.0.0	-
	Databases		8.0.0	-
Data Manipulation Language (DML)	SELECT	Quotation Marks INTERVAL Division Expressions Group By Conversion ROLLUP	8.0.0	-
			8.0.0	-
			8.0.0	-
			8.0.0	-
	INSERT	HIGH_PRIORITY LOW_PRIORITY PARTITION DELAYED IGNORE VALUES ON DUPLICATE KEY UPDATE SET	8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0	-
	UPDATE	LOW_PRIORITY ORDER BY LIMIT IGNORE	8.0.0 8.0.0 8.0.0 8.0.0	-
	REPLACE	LOW_PRIORITY PARTITION DELAYED VALUES SET	8.0.0 8.0.0 8.0.0 8.0.0 8.0.0 8.0.0	-
Transaction Management and Database Management	Transaction Management	TRANSACTION LOCK	8.0.0 8.0.0	-
Transaction Management and Database Management	Database Management	SET CHARACTER	8.0.0	-