MySQL数据库基本操作02–DML
Data Manipulation Language 数据操作语言(增删改)
1.数据插入 insert
# 格式1,可选取对应列插入对应数据,且应一一对应
insert into student(sid,name,gender,age,birth,address,score)
values(1001,'张三','男',18,'2001-12-23','北京',85.5),
(1002,'张四','男',19,'2000-12-23','北京',80.5);
# 格式2
insert into student values(1003,'张华','女',20,'1999-12-01','上海',90),
(1004,'李华','女',20,'1999-10-01','上海',50);
2. 数据修改 update
# 对全表影响
update student set address = '重庆';
# where 条件
update student set address = '北京',score = 100 where id =1005;
3. 数据删除 delete
truncate相对更彻底
4. DML练习题
# 黑马视频P26 练习题
# 1.创建表
create table if not exists employee(
id int,
name varchar(20),
gender varchar(10),
salary double
);
# 2.插入数据
insert into employee (id,name,gender,salary)
values(1,'张三','男',2000),
(2,'李四','男',1000),
(3,'王五','女',4000);
# 3.修改表数据
update employee set salary = 5000;
update employee set salary =3000 where name = '张三';
update employee set salary = 4000,gender ='女' where name = '李四';
update employee set salary =salary + 1000 where name = '王五';