Operation of MySQL data table

1. Create a database table:

CREATE TABLE table_name (fields_name1 datatype,fields_name2 datatype ...);

2. View the table:

Show tables;

3. Create a table with the main health constraint (including Tangokian and multi-character types)

1. Single KEY constraint

Field name data type, primary key[default value]

2. Specify the master after all columns have been defined

Constraint < constraint name >primary key[default value]

4. Multi-field Federated primary key

The main jian is composed of several fields together

P55

Operation of MySQL data table