数据库的练习题（二）

一、给employee表添加数据

insert into employee(id,workno,name,gender,age,idcard,entrydate) value(1,'1','Itcast','男',10,'123456789012345678','2000-01-01');

二、插入全部字段

insert into employee values(2,'2','张无忌','男',18,'123456789012345670','2005-01-01');

三、批量插入

insert into employee values(3,'3','韦一笑','男',38,'123456789012345670','2005-01-01'),(4,'4','赵敏','女',18,'123456789012345670','2005-01-01');

四、修改语句
1、修改id为1的数据，将name修改为itheima

update employee set name='itheima' where id = 1;

2、修改id为1的数据，将name修改为小昭，gender修改为女

update employee set name='小昭',gender='女' where id =1;

3、将所有的员工入职日期修改为：2008-01-01

update employee set entrydate='2008-01-01';

五、删除语句
1、删除gender为女的员工

DELETE from employee WHERE gender='女';

2、删除所有员工

DELETE from employee;