Mysql engine _ MySQL-mysql tutorial

Mysql engine InnoDB is a mysql table that provides transaction security, rollback, crash repair capabilities, and multi-version concurrency control.

MyIsAm storage engine is a common storage engine in Mysql.

All data of the Memory storage engine is stored in the Memory. High speed, but low security.

Default-character-set = utf8

Character-set-server = utf8

Set the table's primary key:

Single primary key

1. primary key

Multiple primary keys

2. primary key (one, two)

Set the foreign key of the table

Contraint foreign key alias foreign key (one, two, three ....) References table name (one, two, three)

The former and the latter types must be consistent, and the latter must be the primary key.

Set non-empty table constraints

Not null

Null

Set unique table constraints

Unique

Set Table attributes to automatically add

Auto_increment

Set the default value of the table attribute

Default "dd"