moving rows from one table to another 1

[miraclemaker]

Hi there. Is there some kind of query that will allow me to move / export some rows from one table to another in the same database?

Thanks

 

[r937]

yes

first, copy the rows from table1 into table2 like this --

insert 
  into table2
     ( foo2
     , bar2
     , qux2
     )
select foo
     , bar
     , qux
  from table1
 where pk1 in ( 1, 3, 5, 937 )

then delete them from table1 --

delete
  from table1
 where pk1 in ( 1, 3, 5, 937 )

rudy

http://r937.com/

SQL Consulting

 

[miraclemaker]

Excellent, thanks.