IF statement inside MySQL trigger

Question

I need some help to complete this trigger. I try it but I don't know what is wrong.

This is the code:

delimiter $$

CREATE TRIGGER attendance_clock AFTER INSERT ON alldevicerecord
FOR EACH ROW
BEGIN
    DECLARE check INT;
    SET check= 1;
    IF (check % 2 == 0) THEN
      INSERT into designation(emp_id, clock_date, clock_in) VALUES (new.id, new.time, new.time);
      check  = check + 1;
    ELSE
      UPDATE designation SET clock_out = new.time WHERE emp_id = NEW.id;
      check = check + 1;
    END IF
END$$

delimiter ;

Anyone can help me please?

what is the error you are getting

Satya
– Satya

2012-04-21 11:12:32 +00:00
Commented Apr 21, 2012 at 11:12 — Satya
– Satya, Commented Apr 21, 2012 at 11:12
what are you trying to do at all?

Andreas Linden
– Andreas Linden

2012-04-21 11:14:24 +00:00
Commented Apr 21, 2012 at 11:14 — Andreas Linden
– Andreas Linden, Commented Apr 21, 2012 at 11:14
try set check = check + 1;

Bohemian
– Bohemian ♦

2012-04-21 11:21:35 +00:00
Commented Apr 21, 2012 at 11:21 — Bohemian
– Bohemian ♦, Commented Apr 21, 2012 at 11:21

informatik01 · Accepted Answer · 2019-12-11 17:59:38Z

29

delimiter $$

CREATE TRIGGER attendance_clock AFTER INSERT ON alldevicerecord
FOR EACH ROW
BEGIN
  DECLARE `check` INT;
  SET `check` = 1;
  IF (`check` % 2 = 0) THEN
    INSERT INTO designation (emp_id, clock_date, clock_in) VALUES(new.id, new.time, new.time);
    SET `check`  = `check` + 1;
  ELSE
    UPDATE designation SET clock_out = new.time WHERE emp_id = NEW.id;
    SET `check`  = `check` + 1;
  END IF;
END$$

delimeter ;

edited Dec 11, 2019 at 17:59

informatik01

16.5k11 gold badges82 silver badges112 bronze badges

answered Apr 21, 2012 at 11:27

juergen d

205k40 gold badges304 silver badges377 bronze badges

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

Collectives™ on Stack Overflow

IF statement inside MySQL trigger

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related