Insert into with select (prepared statement)

Question

I want this query:

INSERT INTO
    users_groups (user_id, group_id)
VALUES
    (?, (SELECT group_id FROM groups WHERE group_name = ?))

tables:

users_groups:
| user_id | group_id |

groups
| group_id | group_name |

How can I get this working?

Embed the value as part of the select statement, you can't mix concepts of a variable and select like you tried. `(SELECT ?, group_id FROM groups WHERE group_name = ?)` — xQbert, Sep 08 '15 at 16:09

cybork · Answer 1 · 2015-09-09T10:03:10.360

Leave 'VALUES' out of your statement. What do you mean with the '?'; parameters? Try the script beneath. Does that serve your purpose?

 INSERT INTO
 users_groups (group_id)
 SELECT group_id FROM groups WHERE group_name = [YOUR SELECTION]

Something like that (?). Or what do you mean exactly what you want to work? (PS: due to not enough rep points I can't add comments, so I have to ask the question here; I'll delete it later if answered)

score 1 · Answer 2 · answered Sep 09 '15 at 06:27

1

Try this;

INSERT INTO
    users_groups (user_id, group_id)
VALUES
    (SELECT ?, group_id FROM groups WHERE group_name = ?)

answered Sep 09 '15 at 06:27

Praveen

8,945
4
31
49

But the user_id (in your query the first ?) isn't in the groups table? Does this work anyway? – Bernd Sep 09 '15 at 12:14
Is there any way the substitute for ? will be taken as column name? – ed22 Aug 04 '18 at 14:41
@ed22 this [link](https://stackoverflow.com/q/3135973/3845604) may help – Praveen Aug 07 '18 at 06:31

Insert into with select (prepared statement)

2 Answers2