Re: MySql

On 12/4/06, Savoy, Melinda <MelindaSavoy@xxxxxxxxxxxxxxx> 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

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV