title: Trigger problems in mysql
body: <p>i have a table named <code>reservation</code> which consists of column <code>reservationStatus</code> and <code>place</code> and another table <code>spot</code> which consists of <code>spot_id</code> and <code>spot_status</code>.
  i have created a trigger in reservation table which should activate after the reservationStatus has been set to 0. but it is not working</p>
  
  <pre><code>DELIMITER $$
  CREATE TRIGGER spotCancel
  AFTER UPDATE ON reservation
  FOR EACH ROW
  BEGIN
  
  IF NEW.reservationStatus = 0 AND OLD.place &lt;=&gt;  'AbcMall' THEN
  UPDATE spot SET spot_status = 0 WHERE spot_id &lt;=&gt; OLD.spot_id;
  END IF;
  
  IF NEW.reservationStatus = 0 AND OLD.place &lt;=&gt; 'XyzGym' THEN
  UPDATE spot1 SET spot_status =0 WHERE spot_id &lt;=&gt; OLD.spot_id;
  
  END IF;
  END$$ 
  DELIMITER ;
  </code></pre>
  
  <p>This query fails silently everytime and i couldnot find the error. I am using xampp and mysql innoDB storage engine.</p>