Introduces the basic operations of MySQL on the database and common configurations of MySQL
1. Basic database configuration (server + client + storage engine configuration)
2. MySQL storage engine description: MyISAM storage engine: does not support transactions, does not support foreign keys, and has fast access speed. Suitable for applications that do not require transaction integrity.
InnDB storage engine: suitable for applications that have high requirements for transaction integrity and require concurrency control. MEMORY storage engine; memory stores data and has fast data access speed, suitable for applications with small data that require fast access
##3. Create database baidu:
create database baidu;
show databases;
##6. Delete database baidu: drop database baidu;
##
The above is the detailed content of Basic operations of MySQL quick start. For more information, please follow other related articles on the PHP Chinese website!
