MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE test(data int, more int);
INSERT INTO test VALUES (10, 20), (30, 40);

Records: 2  Duplicates: 0  Warnings: 0


WITH vars AS (SELECT 5 AS n)
UPDATE test t 
CROSS JOIN vars v
SET t.data = t.data * v.n, 
    t.more = t.more * v.n;

Rows matched: 2  Changed: 2  Warnings: 0


SELECT * FROM test;


data
more


50
100

150
200