title: IF statement inside MySQL trigger
body: <p>I need some help to complete this trigger. I try it but I don't know what is wrong. </p>
  
  <p>This is the code: </p>
  
  <pre><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 ;
  </code></pre>
  
  <p><br>
  Anyone can help me please?</p>