A ramble on MySQL database

One feature of the MySQL database is that the DDL and DML (without select) statements in all SQL statements will display "Query OK" after successful execution.

Unlike other database management systems, the MySQL database management system provides a concept called the storage engine. Because the storage engine is introduced by the MySQL database software in the form of plug-in, the corresponding storage engine can be freely selected according to the actual application and actual need. The following table features the common MySQL storage engine:

　　

Two of our most common storage engines are MyISAM and InnoDB.

Modify the Storage Engine: Method One, "Start"--"program"--"MySQL"--"MySQLServer 5.5"--"MySQL Server Instance Configuration Wizard"--click Next to enter " MySQL Select Use Type "interface-select" Multifunctional database "is the InnoDB storage engine; Select" Non-transaction database Only "is the MyISAM storage engine.

MyISAM Storage Engine: Transactions are not supported, foreign keys are not supported, and access speed is fast.

A ramble on MySQL database