数据准备 :创建表
create table emploee2
(
id int,
name varchar(20),
gender char(1),
saraly double(10,2),
department_id int,
manger_man varchar(10)
)
新增数据 insert into 表 (列名)values (......)
方式一: insert into emploees values(101,'tom','m',5000,20,'zhangsan');
方式二:insert into emploees(id,name,gender,salary,department_id,manager_man)values(102,'tom2','m',6000,230,'lisi')
批量插入数据:
insert into emploees
values(101,'tom','m',5000,20,'zhangsan'),
(102,'tom1','m',6000,30,'zhangsan'),
(103,'tom2','m',7000,40,'zhangsan'),
(104,'tom3','m',8000,50,'zhangsan'),
(105,'tom4','m',9000,60,null)
修改数据 :update 表 set 列名=value where...
#修改一条数据
update emploees set saraly =8000 where name='tom'
#修改多个数据
update emploees set saraly =5000,department_id=25 where name='tom3'
删除数据: delete from table where...
#删除指定数据
delete from emploees where id=102
#删除所有数据
delete from emploees