MySQL, Insert statement with values as select statements

Question

insert into class_pre_req(class_id, cpr_id) values(select class_id from classes where catlg_nbr = 265 and subject_id = 27, select class_id from classes where catlg_nbr = 166 and subject_id = 27);

I am trying into insert into this table with the values as insert statements. I assume I am just using the wrong syntax. Any help please?

Tim Biegeleisen · Accepted Answer · 2018-04-08 03:32:39Z

1

VALUES is only used when inserting literal records. Instead, just insert a select statement consisting of two subqueries:

INSERT INTO class_pre_req (class_id, cpr_id)
SELECT
    (SELECT class_id FROM classes WHERE catlg_nbr = 265 AND subject_id = 27),
    (SELECT class_id FROM classes WHERE catlg_nbr = 166 AND subject_id = 27);

Note that in order for this to work, each subquery would have to return a single value.

edited Apr 8, 2018 at 3:32

answered Apr 8, 2018 at 3:28

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

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

Collectives™ on Stack Overflow

MySQL, Insert statement with values as select statements

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related