DML------对数据库中的数据进行增删改操作

添加数据

---给指定的字段添加数据

INSERT INTO 表名(字段名1,字段名2...) VALUES(值1,值2....);

INSERT INTO employees(NO,empid,empname,sex,age,card,hiredate) VALUES(1001,"1002","张昌","男",22,"430682199001011235","2021-06-12");

---给全部字段添加数据

INSERT INTO 表名 VALUES(值1,值2....);

INSERT INTO employees VALUES(1002,"1003","李华","女",18,"430682199101011235","2020-06-12");

---批量添加数据

INSERT INTO 表名(字段名1,字段名2...) VALUES(值1,值2....),(值1,值2....)...;

INSERT INTO employees(NO,empid,empname,sex,age,card,hiredate)

VALUES(1003,"1004","张方","男",22,"430682199201011235","2022-06-12"),

(1005,"1005","张方方","女",22,"430682199206011235","2022-04-12");

INSERT INTO employees

VALUES(1006,"1006","张方","男",22,"430682199201011235","2022-06-12"),

(1007,"1007","张方方","女",22,"430682199206011235","2022-04-12");

DML修改数据

UPDATE 表名 SET 字段名1=值1,字段名2=值2.....[WHERE 条件];

注意：修改语句中的条件可以有，也可以没有，如果没有条件，修改是整张表的数据。

--实例：把张方方改为李四

UPDATE employees SET empname="李四" WHERE empname="张方方";

DML 删除数据

DELETE FROM 表名 [WHERE 条件];

DELETE FROM employees WHERE NO=1002;

面试题：把drop ,truncate,delete 区别找出来

DML总结：

1.添加数据

insert into 表名 (列段名1......) values(值);

2.更新数据

update 表名 set 字段 名= 值 where 条件

3.删除数据

delete from 表名 where 条件

====================================================================