Lu, Huayi 27019c2991 DWS TOOL 830.201 version

Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>

2024-05-16 07:35:25 +00:00

47 KiB

Raw Permalink Blame History

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
Functions and Expressions	Type Mapping		8.0.0	-
Schema Objects and Data Definition Language (DDL)	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	-

Parent topic: MySQL Syntax Migrating

47 KiB Raw Permalink Blame History

Supported Keywords and Features

47 KiB

Raw Permalink Blame History