Posted By

janetmck on 12/08/08


sql postgres courses oucs-isteam

Versions (?)

Who likes this?

1 person have marked this snippet as a favorite


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.