mysql - INSERT with SELECT - Stack Overflow

Say I have a query that inserts using a select as such: INSERT INTO courses name, location, gid SELECT (name, location, gid) FROM courses WHERE cid = $cid... ... Yes, absolutely, but check your syntax. INSERT INTO courses (name, location, gid) SELECT ...

stackoverflow.com