We have multiple identical schemas. How can I store a query and easily apply it to any of multiple schemas? Bonus points for a drag & drop or point & click method of executing the query.
My first attempt was to set a variable for the schema, like this
SET @db = MySchema; SELECT * from @db.mytable;
but I get
Error Code: 1146. Table 'db.tagdescriptions' doesn't exist.
I'm using MySQL Workbench 6.3, connecting to MySQL Community Server (GPL) 5.6.19-log on Win64.