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
-6522 | Fax: (646) 487-1569 | dle...@univision.net | www.univision.net -Original Message- From: bars0.bars0.bars0 [mailto:bars0.bars0.ba...@gmail.com] Sent: Tuesday, April 08, 2014 4:16 PM To: mysql@lists.mysql.com Subject: Calling function, that operates on another database Hi all. I

Calling function, that operates on another database

2014-04-08 Thread bars0.bars0.bars0
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