It's not gonna happen anytime soon :)
If it were me, though, I'd gladly set up server replication on MySQL if
it's the only thing I need to do to save tens of thousands of dollars... ;).
On the bright side, 4.1 has prepared statements, subselects and derived
tables, and 5.0 has stored procedures :)
Tom Achtenberg wrote:
> Darn. This is quite easy to do in SQL Server. Anyone know if this is going to be
> added in 4.1 or 5.0?
> -----Original Message-----
> From: Adam Hooper [mailto:adamh@stripped]
> Sent: Tuesday, July 22, 2003 10:01 AM
> To: Tom Achtenberg
> Cc: 'mysqlcc@stripped'
> Subject: Re: Select between two servers
> This cannot be done. The closest I can think of is server replication,
> but that's certainly not something that belongs on this mailing list,
> and I'm not the guy to ask ;). I don't even know if it's possible :)
> Adam Hooper
> Tom Achtenberg wrote:
>>I have a local MySQL installed and MyODBC connections to two other MySQL
> databases. In the command center I can execute sql commands on any one individual
> database. What I need to do is select from table on two different servers. I have not
> been able to find the syntax for the from in a select that specifies the server the table
> is in. Can anyone help?
>>SQL Programmer/Report Writer
>>Food for the Hungry US