一、向数据表中增加记录:INSERT
语法结构:
1.INSERT [into] 表名 [字段1,字段2,…] VALUES (val1,val2,…)
INSERT student (name,id,age) VALUES(‘tom’,2,20);
2.INSERT [into] 表名 VALUES(val1,val2,…) 注:需把全部的字段值写到values里面
INSERT student VALUES(‘tom’,2,20);
3.INSERT 表名 (clo_name1,clo_name2)SELECT clo_name1,clo_name2 FROM 表名 #查询数据插入到一个表中
INSERT user id,name SELECT id,name from student;
二、向数据表中删除数据:DELETE
语法结构:
DELETE FROM 表名 [WHERE where_condituon]
DELETE FROM student where id =1;
三、向数据表中更新数据 UPDATE
语法结构
1.单表更新:
UPDATE 表名 SET col_name1={expr1 | DEFAULT}, [col_name2={expr2 | DEFAULT}], …[WHERE where_condition]
UPDATE student id= id+2,name=‘tom’,age=age +3 where id =1;
2.多表更新:
UPDATE table1,[table2],… SET table1.col_name,table2.col_name,… [WHERE where_condition]
UPDATE student s , class c SET s.class_name=‘test00’,c.stu_name=‘test00’ WHERE s.class_id = c.id
这里还可用多表链接查询实现
四、在数据表中查询数据
语法结构:
1.单表查询:
SELECT select_expr [ ]
[ FROM table_references
[WHERE where_condition]
[GROUP BY {col_name} | position [ASC |DESC] …]
[ORDER BY {col_name} | position [ASC |DESC] …]
[LIMIT {[OFF SET}] row_count | row_count OFFSET OFFSET]
]
SELECT age FROM student
WHERE agender=‘男’
GROUP BY grade ORDER BY id DESC;
2.多表查询见:
https://blog.csdn.net/Mr_know/article/details/106298434
如有不对欢迎交流,指正。