1.增加(INSERT)
1.1.直接增:INSERT [INTO] table_name [(col_name,......)] VALUES(val,......),(val1,......),......
1.2.使用子查询(使用较少):INSERT [INTO] table_name SET col_name=val,......
1.3.INSERT [INTO] table_name [(col_name,......)] SELECT ......
2.更新(UPDATE)
2.1.单表更新:
UPDATE table_name SET col_name1={expr|DEFAULT} [,col_name2={expr2|DEFAULT}] [WHERE where_condition]
2.2.多表联合更新
3.删除(DELETE)
3.1.单表删除:
DELETE FROM table_name [WHERE where_condition]
3.2.多表删除
4.查询(SELECT)
4.1.查询的通用表达式
SELECT select_expr[,slect_expr1,......]
[FROM table_name
[WHERE where_condition]
[GROUP BY col_name [ASC|DESC] [HAVING where_condition] ]
[ORDER BY col_name [ASC|DESC] ]
[LIMIT {[offset,] row_count | row_count OFFSET offset} ]
]
4.2.LIMIT限制查询个数:
1)只写一个数字,默认从第一条数据开始返回
2)下标从0开始,如:LIMIT 2,2(从第三条数据开始返回,个数为2条即返回第三条和第四条记录)