SQL基本操作 数据的增删改查 执行 INSERT 、DELETE 、UPDATE、SELECT 等语句实现对表数据的增删改查,相应语法参考 MySQL 5.7,例如: sql INSERT INTO student VALUES(1,'zhangsan','20230812'); INSERT INTO student(id,name) VALUES(2,'lili'); DELETE FROM student WHERE id1; UPDATE student SET name'lisi' WHERE id2; SELECT FROM student WHERE id<5; 注意 UPDATE 和 DELETE 操作如果不带 WHERE 过滤条件是对全表进行操作。