Posted By

janetmck on 12/08/08


Tagged

sql postgres courses oucs-isteam


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

Beppoi


Copy selection from one table to another with changes


 / Published in: SQL
 

  1. CREATE TEMP TABLE tempcourse AS SELECT * FROM bookings WHERE presentation=xxxxxx
  2. UPDATE tempcourse SET presentation=yyyyyy
  3. INSERT INTO bookings SELECT * FROM tempcourse
  4. DROP TABLE tempcourse;

Report this snippet  

You need to login to post a comment.