mysql-record additions and deletions to change the operation

1. Insert Record:

method One: INSERT [into] tbl_name [(col_name,)] {values| VALUE} ({expr | default}, ），（··· ），···

For example:

INSERT users VALUES (NULL, ' Mary ', ' 666666 ', 25, 1);

Method Two: INSERT [into] tbl_name SET col_name={expr | default},

Description: As with the first method, this method can use a subquery (subquery); In addition, this method cannot insert multiple statements at the same time.

Method Three: INSERT [INTRO] tbl_name [(col_name,)] SELECT

Description: This method inserts the query results into the specified data table

mysql-record additions and deletions to change the operation