mysql--data Insert, query, subquery, multi-table connection query

First, the insertion of data

Insert columns into a table sequentially (this is commonly used): INSERT into Table name values (Value1,value2,value3,........)

Insert for a specific column: INSERT into table name (COLUMN1,COLUMN3) VALUES (value 1,value3)

Example: INSERT into customer values (1, ' Lily ', ' female ', ' down Street ');

Insert into customer (Name,sex) VALUES (' Lily ', ' female ');

Second, the data query

5 Types of statements queried: where (conditional query)/having (filter)/group by (group)/order by (sort)/limit (limit number of results)

mysql--data Insert, query, subquery, multi-table connection query