Posted By

janetmck on 12/08/08


Tagged

sql postgres courses oucs-isteam


Versions (?)

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.