0

Let's say I have 50 databases that all have same schema and all have table 'plays'.

Is there any possible way to SELECT all the data from table 'plays' from all the databases at once ?

Is there any way to do this if I dont know how many databases I have ?

Currently I would do this : 

(SELECT * FROM db1.plays WHERE condition)
UNION
(SELECT * FROM db2.plays WHERE condition)
UNION...
(SELECT * FROM db50.plays WHERE condition)

Is there any way to write less code for this ?

Regards

user229044
  • 232,980
  • 40
  • 330
  • 338
NVG
  • 3,248
  • 10
  • 40
  • 60

1 Answers1

0

I'm not sure, but to shorten your code, you could do

Select * FROM db1.plays, db2.plays, ...., db3.plays WHERE <condition>

Another thing that comes to mind is using the table INFORMATION_SCHEMA. Maybe someone else has a better idea.

Steven Ryssaert
  • 1,989
  • 15
  • 25