Re: Calling function, that operates on another database

2014-04-08 Thread Larry Martell
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

RE: Calling function, that operates on another database

2014-04-08 Thread David Lerer
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