mysql-DML学习记录（二）

#增加数据表
insert into employee(id, workno, name, gender, age, idcard, entrydate) valves (1,'1', 'itcast','男',19,'123456789812345678','2000-01-01');
#--修改id为1 的数据，将name修改为itheima
update employee set name ='itheima' WHERE id = 1 ;
#修改id为1 的数据，将name修改为小昭，gender 修改为女
update employee set name ='小昭',gender ='女'where id = 1;
#将所有的员工入职日期修改为 2008-01-01
update employee set entrydate ='2008-01-01';
#删除 gender 为女的员工
DELETE fron employee where gender ='女' ;
#删除所有员工
DELETE FROM employee;