How do I insert multiple rows with a subquery as one of the value?

Question

I'm trying to insert multiple rows to a table where the value of one column is from another query. However I got the following error

more than one row returned by a subquery used as an expression

How should I do this ?

INSERT INTO 
   accounts_account_preferences (account_id, preference_id) 
VALUES 
   ((SELECT account_id 
     FROM accounts_account_preferences 
     WHERE preference_id = 1), 2);

Answer 1

Use INSERT ... SELECT ... without VALUES:

INSERT INTO accounts_account_preferences (account_id, preference_id) 
SELECT account_id, 2 
FROM accounts_account_preferences 
WHERE preference_id = 1