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 not mentioned in the section devoted to mapping such names to
* h...@tbbs.net 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 not
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
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
On Tue, Apr 8, 2014 at 4:15 PM, bars0.bars0.bars0
bars0.bars0.ba...@gmail.com 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,