get previous field value in trigger mysql

Question

I have a trigger like this in MySQL:

DELIMITER $$
CREATE TRIGGER service_before_update BEFORE UPDATE ON service
FOR EACH ROW
BEGIN
    IF NEW.seatCount < (?) THEN
        SIGNAL SQLSTATE '12345';
    END IF;
END$$
DELIMITER ;

instead of (?) I want previous value of "seatCount" is there any easy way or I should use something like this(ServiceNo is a PRI key):

(SELECT seatCount FROM service WHERE serviceNo = NEW.serviceNo LIMIT 1)

erik258 · Accepted Answer · 2015-01-01 18:58:21Z

1

Yeah, it's super easy. OLD.seatCount should do what you want. http://dev.mysql.com/doc/refman/5.0/en/trigger-syntax.html has more information.

answered Jan 1, 2015 at 18:58

erik258

16.5k2 gold badges32 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

get previous field value in trigger mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related