MySQL insert multiple rows with select and one constant value

Question

i would like to insert two values into a table, one value is constant (user_id) and second values are selected from other table. I have an error:

#1064 - Something is wrong in your syntax obok 'select name from payment_methods_default)' w linii 1

insert into payment_methods_assigned_to_users (user_id, name)
VALUES (1, select name from payment_methods_default);

GMB · Accepted Answer · 2020-10-05 09:04:00Z

5

VALUES() lets you insert just one row, while you want to insert multiple rows (one per row in the payment_methods_default table). For this, consider the insert ... select syntax:

insert into payment_methods_assigned_to_users (user_id, name) 
select 1, name from payment_methods_default

answered Oct 5, 2020 at 9:04

GMB

224k25 gold badges103 silver badges151 bronze badges

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

1 Comment

TheRealChx101 Over a year ago

What about multiple rows this way but the FROM table is a subquery?

Collectives™ on Stack Overflow

MySQL insert multiple rows with select and one constant value

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related