Revisions to INSERT with SELECT

added 5 characters in body

edited Nov 7, 2017 at 21:33

The right Syntax for your query is:

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

The right Syntax for your query is:

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

The right Syntax for your query is:

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

Post Undeleted by Martin Rafael Pérez Lara

occurred Nov 7, 2017 at 21:33

Post Deleted by Martin Rafael Pérez Lara

occurred Nov 7, 2017 at 21:32

answered Oct 14, 2015 at 22:26

The right Syntax for your query is:

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

Return to Answer