Calling function, that operates on another database

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

Re: get a partial dump

W dniu 2012-10-18 16:27, Stefan Kuhn pisze: Hi everybody, I want to get insert statements from a mysql database for a number of rows of a table, specified by a where clause. I also need the inserts for the datasets linked via foreign keys in other tables. So I need a sort of partial dump, a bit

Sending an output of a query to file in debian lenny

Hi everyone! I try o send an output of a query in debian lenny, using: SELECTINTO OUTFILE '/my_path/my_file' FROM...but I get an error: ERROR 1 (HY000): Can't create/write to file... (Errcode 13). What's the problem?

Re: Sending an output of a query to file in debian lenny

2010/12/2 Simcha Younger sim...@syounger.com On Thu, 2 Dec 2010 10:06:21 +0100 bars0 bars0 bars0.bars0.ba...@gmail.com wrote: Hi everyone! I try o send an output of a query in debian lenny, using: SELECTINTO OUTFILE '/my_path/my_file' FROM...but I get an error: ERROR 1 (HY000