MySQL database BASICS (III) (records in the operation data table) (continuously updating), mysql updating

MySQL database BASICS (III) (records in the operation data table) (continuously updating), mysql updating

1. INSERT record

Command:, Expr: Expression

Note: If you assign values to the primary key (automatically numbered fields), you can assign values to 'null' or 'default'. The primary key value will still follow the DEFAULT rules.If the column name is omitted, all fields must be assigned a value at a time.

Insert set (rarely used, only one record can be inserted at a time)

Command:

 

INSERT record INSERT SELECT

Command:

 

2. UPDATE a single table UPDATE record

Command: