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-- 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