Re: UPDATE a field SEVERAL times in 1 UPDATE

[Rick James]

Well, this might be the least number of statements:

CREATE TEMPORARY TABLE f381454 (id INT);
INSERT INTO f381454 (id) VALUES ('1'),('2'),('4'),('3'),('4'),('4');
CREATE TEMPORARY TABLE g381454
    SELECT id, COUNT(*) as ct 
        FROM f381454 GROUP BY id;
UPDATE casinogamers c, g381454 b 
    SET c.bucks = c.bucks + b.ct
    WHERE c.id = b.id;