MySQL database Base (iii) (record in Operation data sheet) (continuous update)

1. Inserting a record insert

Command:, expr: Expression

Note: If you assign a value to a primary key (an AutoNumber field), you can assign a value of ' NULL ' or ' default ', the value of the primary key will still follow the default rule, and if you omit the column name, all fields must be assigned one time.

Insert SET (less, only one record can be inserted at a time)

Command:

Inserting records Insert SELECT

Command:

2. Single-table update recording update

Command:

MySQL database Base (iii) (record in Operation data sheet) (continuous update)