【小白日记】数据库中的CRUD sql 语句整理

• insert

INSERT INTO stu_list (NAME , age) VALUES  ("zhangsan",18)

INSERT INTO stu_list VALUES  (NULL,"zhangsan",18)

• delete

DELETE FROM stu_list WHERE id = 6

• query

SELECT * FROM stu_list

• update

UPDATE stu_list SET age =18 WHERE id = 1

转载于:https://www.cnblogs.com/WeiHaoLee/p/10823335.html