Mysql dialect configuration in hibernate_mysqlsqldialect_Micrle_007’s blog

RDBMS dialect DB2 org.hibernate.dialect.DB2Dialect DB2 AS/400 org.hibernate.dialect.DB2400Dialect DB2 OS390 org.hibernate.dialect.DB2390Dialect PostgreSQL org.hibernate.dialect.PostgreSQLDialect MySQL org.hibernate.dialect.MySQLDialect MySQL with InnoDB org.hibernate.dialect.MySQLInnoDBDialect MySQL with MyISAM org.hibernate.dialect.MySQLMyISAMDialect Oracle (any version) org.hibernate.dialect.OracleDialect Oracle 9i/10g org.hibernate.dialect.Oracle9Dialect Sybase org.hibernate.dialect.SybaseDialect Sybase Anywhere org.hibernate.dialect.SybaseAnywhereDialect Microsoft SQL Server org.hibernate.dialect.SQLServerDialect SAP DB org.hibernate.dialect.SAPDBDialect Informix org.hibernate.dialect.InformixDialect HypersonicSQL org.hibernate.dialect.HSQLDialect Ingres org.hibernate.dialect.IngresDialect Progress org.hibernate.dialect.ProgressDialect Mckoi SQL org.hibernate.dialect.MckoiDialect Interbase org.hibernate.dialect.InterbaseDialect Pointbase org.hibernate.dialect.PointbaseDialect FrontBase org.hibernate.dialect.FrontbaseDialect Firebird org.hibernate.dialect.FirebirdDialect Second, the difference between MySQL: InnoDB and MyISAM (Note: MySQLInnoDBDialect and MySQLMyISAMDialect inherit from MySQLDialect.) InnoDB and MyISAM are the two most important data storage engines of MySQL. Both of them can be used to store tables and indexes. Each has its advantages and disadvantages, depending on the specific application. The basic difference is: the MyISAM type does not support advanced processing such as transaction processing, while the InnoDB type supports it. The MyISAM type table emphasizes performance, and its execution is faster than the InnoDB type, but it does not provide transaction support, while InnoDB provides transaction support and advanced database functions such as external keys. InnoDB provides MySQL with transaction (commit), rollback (rollback) and crash recovery capabilities (crash recovery capabilities), multi-version concurrency control (multi-versioned concurrency control) transaction security (transaction-safe (ACID compliant)) type table. InnoDB provides row-level locks (locking…