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 :)
Adam Hooper
adamh@stripped
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
> adamh@stripped
>
> 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?
>>
>>
>>Tom Achtenberg
>>
>>SQL Programmer/Report Writer
>>Food for the Hungry US
>>Information Technologies
>>(480) 609-7750
>>
>>
>>
>
>
