SQLite 3 部分语句

复制旧表house_sourceinfo的部分内容到新表 house_rent

createtable house_rent as select house_id,house_name,house_host,house_tel from house_sourceinfo;

删除表housr_rent

droptable housr_rent;