Re: user last activity and log in

2012-10-05 Thread Singer Wang
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://blogs.oracle.com/MySQL/entry/new_in_mysql_enterprise_edition), but otherwise you cannot do it natively. This does not mean its

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 w...@singerwang.com 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

Re: user last activity and log in

2012-10-05 Thread Johan De Meersman
- Original Message - From: Singer Wang w...@singerwang.com 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)

[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

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

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: (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 null,