数据库中的一个表格名字为student,其中包含五个信息sno,sname,ssex,sage,sdept。
1、插入
INSERT INTO student(sno,sname,ssex,sage,sdept) VALUES(9900,‘王二’,‘女’,‘18’,‘MA’);
2、选中删除
DELETE FROM student WHERE sname = ‘张三’;
3、更改信息
UPDATE student SET sname = ‘李四’,ssex = ‘女’ WHERE sname = ‘二’ AND ssex = ‘女’;
满足两个条件,一个是1003,一个是女
4、查询
SELECT * FROM student;
SELECT为搜索,*代表所有