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	-
  				-
  	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	-
  	Comment		8.0.0	-
  	Databases		8.0.0	-
  Data Manipulation Language (DML)	Quotation Marks INTERVAL Division Expressions Group By Conversion ROLLUP		8.0.0	-
  	INSERT	HIGH_PRIORITY LOW_PRIORITY PARTITION DELAYED IGNORE VALUES ON DUPLICATE KEY UPDATE SET	8.0.0	-
  	UPDATE	LOW_PRIORITY ORDER BY LIMIT IGNORE	8.0.0	-
  	REPLACE	LOW_PRIORITY PARTITION DELAYED VALUES SET	8.0.0	-
  Transaction Management and Database Management	Transaction Management	TRANSACTION LOCK	8.0.0	-
  	Database Management		8.0.0	-