Multiply id with triggers

Question

Multiply id with triggers

Navigation

#1 by (0 votes)

0

I am trying to multiply the ID with a trigger, but it returns the same result.

DELIMITER //
DROP TRIGGER IF EXISTS incrementID //
CREATE TRIGGER incrementID BEFORE UPDATE ON fine 
FOR EACH ROW
BEGIN
UPDATE OLD.id SET NEW.id = OLD.id * 1000;
END//

sql

asked by kitkat 21.05.2018 в 11:32

source

1 answer

Error closing select cursor with SQLite and changing fragments TemplateField asp

score 0 · Answer 1

I do not understand very well the UPDATE that you raise. Try this way to see how.

DELIMITER //
DROP TRIGGER IF EXISTS incrementID //
CREATE TRIGGER incrementID BEFORE UPDATE ON fine 
FOR EACH ROW
BEGIN
    UPDATE fine SET id = NEW.id * 1000 WHERE id = OLD.id;
END//