根据旧表创建新表并且将旧表的数据复制到新表中

select * into liny_price_index_class_week2017 from liny_price_index_class_week where to_char(createddate,'yyyy-MM-dd hh:MM:ss') like '%2017%'

根据旧表创建新表 只创建表结构

create table liny_price_index_class_week2016 (like liny_price_index_class_week);