增加(insert)
- INSERT INTO STUDENT(`NAME`) VALUES ('赵六')
- INSERT INTO STUDENT SET NAME='胡歌'
1:支持多条插入与子查询
INSERT INTO STUDENT(`NAME`)
SELECT CNAME
FROM COURSE
WHERE CID=1
修改(update)
UPDATE STUDENT S LEFT JOIN COURSE C ON S.CID=C.CID
SET S.NAME='江疏影'
WHERE S.ID=6#把course的某一列的数据复制到course_bak某一列
UPDATE course_bak SET course_bak.cname=(SELECT course.cname FROM course WHERE course_bak.cid=course.cid)
删除(delete)
- delete from 表名 where 条件
- truncate table 表名
区别: