创建表 更改表名，用子查询增加数据，修改数据，删除数据

--创建表

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