DML 数据库操作
DML 添加数据(insert)
insert into tb_employee (coller,id,name,sex,age,card,entry)
values (1,'1','张三','男',18,'000000000000000000','2021-03-05');
insert into tb_employee values
(6,'6','张三6','男',18,'000000000000000006','2021-03-05');
insert into tb_employee (coller,id,name,sex,age,card,entry)
values (2,'2','李四','男',19,'000000000000000002','2021-03-05'),
(3,'3','李四3','男',19,'000000000000000003','2021-03-05'),
(4,'4','李四4','男',19,'000000000000000004','2021-03-05'),
(5,'5','李四5','男',19,'000000000000000005','2021-03-05');
insert into tb_employee values
(7,'7','李四8','男',19,'000000000000000007','2021-03-05'),
(8,'8','李四8','男',19,'000000000000000008','2021-03-05'),
(9,'9','李四9','男',19,'000000000000000009','2021-03-05'),
(10,'10','李四10','男',19,'000000000000000010','2021-03-05');
简单的数据查询
select name,entry,card from tb_employee;
DML 数据修改(update)
update tb_employee set coller = 11,id=11,sex='女',age=20,card ='000000000000000011' where coller =1;
update tb_employee set entry='2024-03-05' where entry ='2021-03-05';
DML删除数据(delete)
delete from tb_employee where card = '000000000000000002';
delete from tb_employee ;