MySql（2）-添加-修改-删除

--插入语句（添加）
--INSERT INTO 表名 ([字段名1,字段名2]) VALUES ('值'),('值'),('值')
INSERT INTO `student` (`name`) VALUES ('一叶知秋')
INSERT INTO student (`id`) VALUES (3)
INSERT INTO student (`id` ,`name`,`pwd`) VALUES (2,'夜雨声烦','aaaaa')
INSERT INTO student (`sex`) VALUES ('男'),('男')
INSERT INTO student VALUES (6,'大漠孤烟','bbbbbb','男','1999-09-02','132@qq.com')

 

---

 

--修改  UPDATE
--UPDATE 表名 SET colnum_name = VALUE,[colnum_name = VALUE] WHERE [条件]
--不指定条件的情况下，会改动所有的信息
UPDATE student SET `name` = '一枪穿云' WHERE id=3
UPDATE student SET `name` = '沐雨橙风',`sex` = '女'WHERE id=4

UPDATE student SET `name` = '索克萨尔' WHERE pwd=123456 AND sex='男'                

<>和这个！=都是不等于的意思

---

--删除  DELETE
DELETE FROM student WHERE id=1

--DELETE 与 TRUNCATE 的区别
DELETE FROM student --不会影响自增
TRUNCATE TABLE `student`  --自增归零