I have a query that inserts using a SELECT statement:

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

Is it possible to only select “name, location” for the insert, and set gid to something else in the query?

8 Answers
8

Leave a Reply

Your email address will not be published. Required fields are marked *