On Tue, Apr 8, 2014 at 4:15 PM, bars0.bars0.bars0
wrote:
> Hi all.
>
> I have standard select statement and on one column I want to run function,
> that will connect to another database (same server).
> Is this possible?
>
> High level example:
>
> SELECT db1.clients.client_id, getTurnover(db1.cli
Chris, take a look at Federated tables
https://dev.mysql.com/doc/refman/5.5/en/federated-storage-engine.html
No, it is not as easy as Oracle's dblinks.
David.
David Lerer | Director, Database Administration | Interactive | 605 Third
Avenue, 12th Floor, New York, NY 10158
Direct: (646) 487-6522
Hi all.
I have standard select statement and on one column I want to run
function, that will connect to another database (same server).
Is this possible?
High level example:
SELECT db1.clients.client_id, getTurnover(db1.clients.client_id) FROM
db1.clients;
AND getTurnover($id) body would b
* h...@tbbs.net [140407 23:09]:
> 2014/04/07 08:02 -0800, Tim Johnson
> 2)mysqldump forces all database names to lower case in the "CREATE
> DATABASE" statement. I know, one shouldn't use upper case in
> database names, but :) tell that to my clients.
>
> Why not? That is
