MySQL Database operations 2-NEW, delete database

New database: Code:

Create  database name;

Attention:

1. Database name preferably using the _db suffix, easy to identify the user database,

2. User-created database only user account and root are authorized to use.

Example:

Create database test_db;

To delete a database: Code:

Drop  database name;

Example:

Drop database test_db;

Show all databases: Code:

show databases;

Attention:

1.databases is a plural form.

Database Storage Engine: Code:

Show engines;

Attention:

1. To display the engine supported by the database, the Support field is supported for Yes,

2. The default database engine is the INNODB, transactional database-preferred engine.

Query the default engine: Code:

 like ' Storage_engine ';

Attention:

1. Quotation marks do not differentiate between single and double.

MySQL Database operations 2-NEW, delete database