数据库的增删改查
增:
insert into employee(name,sex) values ('AAA','m')
insert employee (name,sex) values ('BBB','m')
insert into employee(name,sex) values('CCC','m')
查看结果:select * from employee
显示如下:
AAA m
BBB m
CCC m
删:
delete from employee
where name='CCC'
查看结果:select * from employee
显示如下:
AAA m
BBB m
改:
update employee
set sex='f'
where name='BBB'
查看结果:select * from employee
显示如下:
AAA m
BBB f
查:
select * from employee
where sex='m'
显示如下:
AAA m
BBB f
暂记下