How to insert into a table data and select from another table?

Question

I want to do something like this:

My tb_b: --------------- B | C // Columns --------------- 'y' | 'z' // row ---------------

EX: INSERT INTO tb_a(a,b,c) VALUES ('x',SELECT * from tb_b)

I want this result:

My tb_a: ----------------- A | B | C // Columns ----------------- 'x' | 'y' | 'z' // row -----------------

How to Insert into table a data and selected rows from tb_b?

Explosion Pills · Accepted Answer · 2013-05-29 21:34:51Z

4

INSERT INTO tb_a (a, b, c) SELECT 'x', tb_b.B, tb_b.C FROM tb_b

answered May 29, 2013 at 21:34

Explosion Pills

192k56 gold badges341 silver badges417 bronze badges

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

1 Comment

clarkson Over a year ago

What does a,b,c refer to in tb_a (a, b, c)? How to insert for 3 fields in tb_a when it only have two columns?Also does SELECT 'x', tb_b.B, tb_b.C FROM tb_b means select row x , values in columns B and C

Collectives™ on Stack Overflow

How to insert into a table data and select from another table?

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related