lovejerry
2/28/2018 - 10:23 AM
将查询的数据插入到一个新表里
-- select id,profileid into propertyvalues from propertyvalue
INSERT INTO propertyvalues SELECT id,profileid FROM propertyvalue-- select id,profileid into propertyvalues from propertyvalue
INSERT INTO propertyvalues SELECT id,profileid FROM propertyvalue