MySQL 8.0

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

CREATE TABLE test (id INT);
INSERT INTO test VALUES (1), (2), (3), (4);

Records: 4  Duplicates: 0  Warnings: 0


CREATE TRIGGER prevent_multiple_update
BEFORE UPDATE ON test
FOR EACH ROW
BEGIN
       IF @update_timestamp = NOW(6) THEN
         SIGNAL SQLSTATE '45000'
         SET MESSAGE_TEXT = 'Cannot update more than one line per time';
       ELSE 
         SET @update_timestamp = NOW(6);
       END IF;
END
UPDATE test SET id = 11 WHERE id = 1;

Rows matched: 1  Changed: 1  Warnings: 0


UPDATE test SET id = id + 10 WHERE id < 10;

Cannot update more than one line per time


SELECT * FROM test;


id


11

2

3

4