squirrel-sql-users

[Squirrel-sql-users] MySql

[Savoy, M. <Mel...@te...>]

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.

Any suggestions? =20



Melinda Savoy
Sr. Programmer Analyst
Financial Applications - Enterprise Systems



The information contained in this message and any attachments is intended=
 only for the use of the individual or entity to which it is addressed, a=
nd may contain information that is PRIVILEGED, CONFIDENTIAL, and exempt f=
rom disclosure under applicable law.  If you are not the intended recipie=
nt, you are prohibited from copying, distributing, or using the informati=
on.  Please contact the sender immediately by return e-mail and delete th=
e original message from your system.

Re: [Squirrel-sql-users] MySql

[Robert M. <rob...@gm...>]

On 12/4/06, Savoy, Melinda <Mel...@te...> wrote:
>
>
>
> 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.

As long as in each statement you qualify the table name with the
schema it shouldn't be a problem.  I'm using 5.0.22 and I can create
and drop tables in schemas other than the one I connected to (<dbname>
in url jdbc:mysql://localhost:3306/<dbname>).  Note: there is ongoing
consideration being given to the fact that only one catalog's tables
(catalog is really the term for schema in MySQL) can be accessed in
the object tree based on the catalog selected in the catalog selector
at the top of the session window.

Rob