--创建表
create table userhouses2 (warehousename varchar2(50) not null,username varchar2(30) not null)
--更改表名
rename userwarehouse2 to userwarehouses2
select * from userwarehouses2
--插入数据
insert into userwarehouses2 warehouseid values ((select description from warehouses where warehouseid = 6),'jon')
select * from userwarehouses2
--更新数据一种方法
update userwarehouses2 set username=(select description from warehouses where warehouseid = 7) where warehousename ='紧固件'
select * from userwarehouses2
--更新数据二种方法
update userwarehouses2 set username = 'asan' where warehousename = (select description from warehouses where warehouseid = 6)
select * from userwarehouses2
--删除数据
delete userwarehouses2 where warehousename = (select description from warehouses where warehouseid =7)
select * from userwarehouses2