SQL statement for MySQL database

MySQL database naming rules (identifier rules):

1. cannot be the same name as existing names;
2. consists of uppercase and lowercase letters, data, underscores, @, #, and $ symbols;
3. The first letter cannot be a number and a $ character.
4. Spaces and special characters are not allowed.
5. The reserved word for MySQL is not allowed.
6. The length is not less than 128 bits.

When you execute an SQL statement, you can use the ";", "\g", or "\g" notation to indicate the end of the statement. But the "\g" display effect is more beautiful.

Creating databases: CREATE DATABASE database_name

View database: Show databases

Select database: Use database_name

Deleting databases: Dorp database database_name

View Engine: Show engines

　　SHOW VARIABLES like ' have% ' This command doesn't know what it's for.

　　View default storage Engine: Show VARIABLES like ' storage_engine% '

　　

SQL statement for MySQL database