Return to Snippet

Revision: 10105
at December 8, 2008 11:32 by janetmck

Initial Code
CREATE TEMP TABLE tempcourse as SELECT * FROM bookings WHERE presentation=xxxxxx
UPDATE tempcourse SET presentation=yyyyyy
INSERT INTO bookings SELECT * FROM tempcourse
DROP TABLE tempcourse;

Initial URL

Initial Description

Initial Title
Copy selection from one table to another with changes

Initial Tags

Initial Language