Re: How to use "use" for a specific host

2004-09-03 Thread Roger Baklund
* 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

RE: How to use "use" for a specific host

2004-09-02 Thread Brian Menke
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 -

Re: How to use "use" for a specific host

2004-09-02 Thread Roger Baklund
* 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.

Re: How to use "use" for a specific host

2004-09-02 Thread V. M. Brasseur
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