MySQL Syntax Migration

This section lists the MySQL syntax features supported by the syntax migration tool, and provides the MySQL syntax and the equivalent GaussDB(DWS) syntax for each feature. The syntax listed in this section illustrates the internal logic for migrating MySQL scripts.

This section is also a reference for the database migration team and for the on-site verification of MySQL script migration.

• Basic Data Types
  
• Table (Optional)
  
• Table Operations
  
• Unique Indexes
  
• Normal and Prefix Indexes
  
• Hash Indexes
  
• B-tree Indexes
  
• Spatial Indexes
  
• Delete an Index
  
• Comments
  
• Databases
  
• Data Manipulation Language (DML)
  
• Transaction Management and Database Management