Re: (real) silly question about variables...

2012-10-05 Thread hsv
For this, 2012/10/04 16:13 +0200, MAS! IF(GROUP_CONCAT(DISTINCT secA.sec_code SEPARATOR '|') is null, IF(GROUP_CONCAT(DISTINCT secB.sec_code SEPARATOR '|') is nul

date-IFNULL-sum bug?

2012-10-05 Thread hsv
Can anyone explain this to me? The first one seems quite wrong; the rest make perfect sense. mysql> select ifnull(date('1900/5/3'), date('1900/01/01')) + 1; +--+ | ifnull(date('1900/5/3'), date('1900/01/01')) + 1 | +--

RE: [Info] Business db

2012-10-05 Thread Martin Gainty
indian spammer please take me off your list *Warm Regards* __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterl

[Info] Business db

2012-10-05 Thread Catherine
Hi, As entrepreneurs we are always looking for effective ways to land new clients. By acquiring new clients, we are able to increase sales, build credibility and grow our small businesses. There are proven strategies that work for. Email marketing is indeed an effective and efficient way to ma

Re: user last activity and log in

2012-10-05 Thread Johan De Meersman
- Original Message - > From: "Singer Wang" > > 2) use a init-connect to log logins but that doesn't work for users > with super privileges as Keith mentioned below (thanks Keith for actually > trying to help!) That is indeed quite the nifty trick. Thanks, Keith :-) > 3) Write your own p

Re: user last activity and log in

2012-10-05 Thread Singer Wang
My bad actually, the MySQL Enterprise Audit is available in MySQL 5.5 S On Fri, Oct 5, 2012 at 2:14 AM, Singer Wang wrote: > Mellow greetings, > > Enhance your calm. Lets get our facts straight and not go off our > rockers. MySQL 5.6 Enterprise edition will be able to do this natively ( > https