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.
-Brian -----Original Message----- From: V. M. Brasseur [mailto:[EMAIL PROTECTED] Sent: Thursday, September 02, 2004 3:00 PM To: Brian Menke Cc: [EMAIL PROTECTED] 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 this one: mysql -h hostname [-u username -p -P port] databasename http://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. Cheers, --V 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 > like: > > > > USE [EMAIL PROTECTED] I have tried several permutations of that but > can't quite seem to get the syntax just right. > > > > Thanks. > > > > -Brian > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
