title: Display a message when trigger fires in phpMyAdmin
body: <p>I have a table where stock quantity is recorded. I set trigger to warn the user when stock goes low. When testing it, the trigger fires, displays the message, but the stock is not updated. What do I do wrong? Is there another way to set the trigger (not using SIGNAL SQLSTATE)? I use phpMyAdmin 4.2.7.1 in uWamp. Thank you for suggestions.</p>
  
  <p>Code for the trigger:</p>
  
  <pre><code>DELIMITER $$
  CREATE TRIGGER low_stock_message  
  AFTER update ON stock_quantity 
  FOR EACH ROW BEGIN
      IF (NEW.Regular_Menu &lt; 50) THEN 
          SIGNAL SQLSTATE '02000' SET MESSAGE_TEXT = 'Warning, Regular Menu has a low stock!';
      END IF;
      IF (NEW.Savers &lt; 50) THEN 
          SIGNAL SQLSTATE '02000' SET MESSAGE_TEXT = 'Warning, Savers Menu has a low stock';
      END IF;
      IF (NEW.Breakfast &lt; 50) THEN 
          SIGNAL SQLSTATE '02000' SET MESSAGE_TEXT = 'Warning,  Breakfast Menu has a low stock!';
      END IF;
  END$$
  DELIMITER ;
  </code></pre>
  
  <p>Test query:</p>
  
  <pre><code>UPDATE stock_quantity
  SET Regular_Menu=48
  WHERE Outlet_ID=1;
  </code></pre>