mysql insert into table from multiple select queries

Question

How do i combine this into a single insert

INSERT INTO masterTable (count1) select count(*) as count1 from tablex
INSERT INTO masterTable (count2) select count(*) as count2 from tabley
INSERT INTO masterTable (count3) select count(*) as count3 from tablez

Rodrigo Murillo · Accepted Answer · 2016-01-23 02:38:43Z

1

INSERT INTO MasterTable (count1,count2,count3) 
VALUES ((select count(*) from tablex),(select count(*) from tabley),(select count(*) from tablez))

edited Jan 23, 2016 at 2:38

answered Jan 22, 2016 at 17:35

Rodrigo Murillo

13.7k2 gold badges35 silver badges53 bronze badges

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

1 Comment

Santosh Pillai Over a year ago

I had tried the same before posting, but seeing syntax error

Collectives™ on Stack Overflow

mysql insert into table from multiple select queries

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