My solution is to create as many aliases as schemes you need to access, each for one schema. Then I can run cross-schema queries by specifying alias (I actually use it for Sybase,
but it should work for MySQL as well).
Alexandre Peshansky, MS
Senior Bioinformatics Analyst, Research Informatics Core (RIC)
Einstein-Montefiore Institute for Clinical and Translational Research (ICTR)
Albert Einstein College of Medicine
1300 Morris Park Ave, Mazer Bldg., Rm 534 Bronx, NY 10461
(718) 430-2440 (Mo, We, Fr) (718) 920-4885 (Tu & Th)
From: Oleg Poleshuk [firstname.lastname@example.org]
Sent: Wednesday, January 23, 2013 11:31 AM
Subject: [Squirrel-sql-users] MySql Schema load
I'm using SQuirreL SQL 3.4.0 to access my local MySql database.
Connection is opened fine, but I have to manually specify active Schema if I want to see it's tables.
It makes impossible to write requests for multiple schemas as SQuirreL SQL doesn't recognize tables from non-current schema.
Alias properties -> Schemas is set to Load all and cache all Schemas. If I set it to Specify schema loading and caching and click on "Connect database to refresh Schema table" nothing happens. I enabled debug logging but couldn't find anything useful in
a log file.
I'm using latest Mysql Connector 5.1.22.
Thanks in advance for your help!