Linux-mysql Database 2

1. Create a new database

The statement format is CREATE DATABASE <数据库名字>; , (note Do not miss ; the semicolon), the previous CREATE DATABASE can also use lowercase, the specific command is:

2. Connect to the database

3. New data table

4. Data type

The difference between char and varchar: the length of the char is fixed, and the length of the varchar can vary

The difference between enum and SET: The value of the enum type data must be one of the values enumerated at the time of the definition, that is, a single selection, and the value of the set type can be multiple.

5. Inserting data

Linux-mysql Database 2