Introduction to simple operation of mysql database

The following mainly brings you the introduction of simple operation of mysql database, I hope these contents can bring you practical use, this is also the main purpose of this article that I edit simple operation of mysql database to introduce. All right, don't talk too much nonsense, let's just read the following.

1. Show all databases:

SHOW DATABASES

2. Create a database:

CREATE DATABASE database name

3. Select the database you created:

USE database name

4. Delete the database:

DROP database name

5. When creating a database, determine whether it exists, specify the encoding, and proofread the rules:

CREATE DATABASE IF NOT EXISTS database name DEFAULT CHARSET UTF8 COLLATE UTF8_GENERAL_CI

For the above on the simple operation of mysql database introduction, we do not think it is very helpful. If you need to know more, please continue to follow our industry information. I'm sure you'll like it.