RsD0p9BK
8/4/2016 - 5:28 AM

insert_with_select.sql

-- INSERT with SELECT
-- http://stackoverflow.com/questions/5391344/insert-with-select

INSERT courses (name, location, gid) 
SELECT (name, location, gid) 
FROM courses 
WHERE cid = $cid