I'm working with a code base where each time a routine is run, it creates a new schema in MySQL with identical structure.
What I'm looking to do is to iterate over all schemas and run a query on a given table in that schema. Ideally, it would also print out the name of the schema on each result line.
I can't figure out a way that doesn't involve building a heady sproc to do this.
0 Replies