Update multiple MySql records

Multiple MySql records update

create temporary table tmp(
	client_id INT(11),
	amount char(2)
);

INSERT INTO tmp 
	SELECT client_id, amount + 10
	FROM clients;

UPDATE clients as r
INNER JOIN tmp c ON c.client_id = r.client_id
SET r.amount = c.amount
WHERE c.amount is not null;

DROP TABLE IF EXISTS tmp;