复制旧表house_sourceinfo的部分内容到新表 house_rent
create table house_rent as select house_id,house_name,house_host,house_tel from house_sourceinfo;
删除表housr_rent
drop table housr_rent;
复制旧表house_sourceinfo的部分内容到新表 house_rent
create table house_rent as select house_id,house_name,house_host,house_tel from house_sourceinfo;
删除表housr_rent
drop table housr_rent;