Basic operations of MySQL quick start

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;

##4. View database baidu:

show databases;

5. Use database baidu: use baidu;

##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!