SQL DML增删改操作

最新推荐文章于 2025-05-20 19:43:23 发布

python_136

最新推荐文章于 2025-05-20 19:43:23 发布

阅读量227

点赞数 1

分类专栏： MySQL数据库文章标签： sql java 数据库

本文链接：https://blog.csdn.net/python_136/article/details/143886040

版权

MySQL数据库专栏收录该内容

9 篇文章

订阅专栏

# 插入数据
insert into  employee(id, workno, name, gender, age, idcard, entrydate)
values (1,'1','itcat','男',18,'431228200008261522','2020-01-01');

insert into  employee(id, workno, name, gender, age, idcard, entrydate)
values (2,'2','itcat2','男',11,'431228200008261512','2020-01-02');

select * from employee;

insert into  employee(id, workno, name, gender, age, idcard, entrydate)
values (3,'3','itcat3','男',12,'431228200008261514','2020-01-03'),
(4,'4','itcat4','男',21,'431228200008261513','2020-01-09');

# --更新数据
update employee set name='itc' where id=1;
update employee set gender='女', idcard='4312282000011111' where id=1;
update employee set entrydate='2018-01-01';


delete from employee where gender='女';
-- 删除所有数据
delete from employee;