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; -- 查询

浙公网安备 33010602011771号