Hello,

I want to update the nb_mail column with this query but the select query
returns empty results in same case while i need 0 value.
An idea please?

Thanks you

UPDATE users u
SET nb_mail = nb_mail +
(SELECT count(*)
FROM event as e
WHERE type='mail' AND u.login = e.login
GROUP BY login)

Le 20/02/2011 20:15, Julien Arlandis a écrit :
I found a solution :

UPDATE users u
SET nb_mail = nb_mail +
IFNULL((SELECT count(*)
FROM event as e
WHERE type='mail' AND u.login = e.login
GROUP BY login), 0)

On 2011-02-20 20:15, Julien Arlandis wrote:
What is the purpose of "GROUP BY login"?

/Lennart