MYSQL DML 增加数据

增加:insert
修改:update
删除:delete

INSERT INTO 表名(1,2,3) values(a,b,c);
insert into employee(id,workno,name,gender,age,idcard,entrydate) values(1,'1','张三','男',18,‘430000000000000’,‘2020-01-01’);-- 添加数据
insert into employee  values(2,'002','李四','男',19,'430111111111111','2021-01-01');
SELECT * FROM employee;
select * from employee; -- 查询

image

posted on 2024-09-28 14:16  di7gan  阅读(11)  评论(0)    收藏  举报

导航