* Brian Menke
[...]
> When I update one table on one machine, the other table of the
> same name on the other machine also gets updated.
Sounds like replication... are you sure the machines are not set up as
master/slave?
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.m
e.
-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 -
* Brian Menke
> 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.
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.m
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