SQL use result in same query as variable

Question

I have two tables:

users (id, email)
devices (id,name, userid)

I want to insert a new device on insert ther userid based on the email in the users table:

INSERT INTO devices (name, userid) VALUES ('devicename', retrievedUserId)

How can I pass the id from the users table to above query?

SELECT id from users WHERE email = '[email protected]'

I would like something like this:

INSERT INTO devices (name, userid) VALUES ('devicename', SELECT id from users WHERE email = '[email protected]')

But with correct syntax :) It has been a while since I wrote vanilla SQL

John Cappelletti · Accepted Answer · 2016-12-23 17:45:45Z

2

INSERT INTO devices (name, userid)  
SELECT 'devicename',id from users WHERE email = '[email protected]'

answered Dec 23, 2016 at 17:45

John Cappelletti

82.3k7 gold badges50 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1