I am using MySql 5.0 and I connected to this database via Squirrel SQL. I have multiple schemas/databases under my localhost. However, when I try and run a .sql script that drops tables from multiple schemas & then populates them in the various schemas I run into an error saying that it does not recognize the first schema name to drop the table. I can run this thru MySQL but not through Squirrel and it would be great if I could.
Sr. Programmer Analyst
Financial Applications - Enterprise Systems