Thank you for your replies. I should have been more specific. I was just
using the sql editor in MySQL Control Center. I have two databases that I'm
managing that sit on different physical machines, but have the same database
names and table names etc., basically a test environment and a production
environment. When I update one table on one machine, the other table of the
same name on the other machine also gets updated. I swear it happened even
though I intentionally disconnected from the other database. The same thing
happened when I used MySQL Front. It's very bizarre.
From: V. M. Brasseur
Sent: Thursday, September 02, 2004 3:00 PM
To: Brian Menke
Subject: Re: How to use "use" for a specific host
Are you using the mysql client to connect? If so, you can use the -h
and -D flags:
mysql -h hostname [-u username -p -P port] -D databasename
The -D flag isn't even necessary. The command above is equivalent to
mysql -h hostname [-u username -p -P port] databasenamehttp://dev.mysql.com/doc/mysql/en/mysql.html
If you're writing your own client, you chould check the API
documentation for the language you're using.
If you're using a completely different client, check the docs for it.
Be one with your manual. Or be one with your many manuals. I leave it
to you to figure out that existential math.
Brian Menke wrote:
I'm trying to specify a host name and database name to do an update to a
table. I can't quite figure out what the correct syntax is? Is it something
USE databasename@hostname? I have tried several permutations of that but
can't quite seem to get the syntax just right.