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
sql

Initial Language
SQL