Member Avatar for RazorRamon

hello,

I have a situation that i'm wondering if there's a solution. I have specific databases for different cities in texas. I plan on adding more but i do not nkow how many more or what their names will be. Every city is going to have the same tables in them. I want to UNION all the similar tables in every database. Is it possible to query every database.specifictable without knowing the names of all of the databases yet.

Thanks in advance

Edited by RazorRamon because: spelling
  • 2 Contributors
  • 1 Reply
  • 76 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

You can build your query, based on the output of the SHOW DATABASES query. Note that this can get real slow.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.