Insert
auto_increment #如果序号不连续，将自动将序号中的最大值+1
INSERT [INTO] tbl_name [(col_name,....)] VALUES ( ..., ...)
INSERT [INTO] tbl_name SET col_name = value, ..... #一次只能插入一条,所有字段
INSERT [INTO] Table2(field1,field2,...) SELECT value1,value2,... FROM Table1 #Table2必须存在
SELECT vale1, value2 INTO Table2 FROM Table1 #Table2不存在
Update
UPDATE tbl_name SET column = value,..... [WHERE condition] #更新一条数据或者一个表中的数据
Delete
DELETE FROM tbl_name [WHERE condition]
Select
AS
LIMIT start,number