MySQL Basics: manipulating databases

MySQL Operations database

1. Create a database

CREATE database name;

2. Show created Database

SHOW DATABASES;

3. Select the database you have created

Use database name;

4. Deleting a database

DROP database name;

5. Database Storage Engine

InnoDB: is a reliable transaction processing engine, it does not support full-text search;

MyISAM: The function is equivalent to MyISAM, but because the data is stored in memory (not disk), it is very fast (especially suitable for temporary tables);

MEMORY: is an extremely high performance engine that supports full text search, but does not support transactional processing.

...

MySQL Basics: manipulating databases