Názor k článku Co nefunguje v MySQL a jak to obejít od dush - Ale to je stale to same, to lze...

Ale to je stale to same, to lze napsat napr. takto

UPDATE tabulka
SET sloupecek = (SELECT SUM(neco) FROM (SELECT * FROM tabulka) AS x)
WHERE tabulka.id = 1;