title: unexpected error in trigger when export
body: <p>Documentation says that</p>
  
  <blockquote>
    <p>There cannot be two triggers for a given table that have the same
    trigger action time and event.</p>
  </blockquote>
  
  <p>I use mysql 5.5.16. I created two triggers. <code>upd_check1</code> and <code>sale_tri</code>. I am sure that my two trigger perform two different tables on <code>INSERT</code> event. But why I get this error in both triggers. when I try export database(<strong>phpmyadmin doesn't show error but mysql workbench, heidisql, query browser show error</strong>).  </p>
  
  <blockquote>
    <p>SQL Error (1235): This version of MySQL doesn't yet support 'multiple
    triggers with the same action time and event for one table'</p>
  </blockquote>
  
  <p>Here my <code>upd_check1</code> trigger</p>
  
  <pre><code>--
  -- Triggers `product_purchases`
  --
  DROP TRIGGER IF EXISTS `upd_check1`;
  DELIMITER //
  CREATE TRIGGER `upd_check1` AFTER INSERT ON `product_purchases`
   FOR EACH ROW BEGIN
    DECLARE X INTEGER;
    SET X = (SELECT product_id FROM product_stock where product_id = NEW.product_id );
    IF NEW.product_id =X  THEN
    UPDATE
      product_stock AS S,
      product_purchase_item AS I,
      product_purchases AS P
    SET
      S.product_total_quantity=S.product_total_quantity+I.quantity
    WHERE
      S.product_id=I.product_id
    AND
      I.product_purchase_item_id=P.product_purchase_item_id
    AND
      P.product_purchase_id=NEW.product_purchase_id;
    ELSE
      INSERT INTO
        product_stock (product_id,product_total_quantity)
      SELECT
        product_id, quantity
      FROM
        product_purchase_item
      WHERE
        product_purchase_item_id=NEW.product_purchase_item_id;
    END IF;
  
    END
  //
  DELIMITER ;
  </code></pre>
  
  <p>And Here my <code>sale tri</code> trigger</p>
  
  <pre><code>--
  -- Triggers `product_sales`
  --
  DROP TRIGGER IF EXISTS `sale_tri`;
  DELIMITER //
  CREATE TRIGGER `sale_tri` AFTER INSERT ON `product_sales`
   FOR EACH ROW BEGIN
         DECLARE X INTEGER;
  
          SET X = (SELECT product_id FROM product_stock where product_id = NEW.product_id );
          IF NEW.product_id =X THEN
            update product_stock as s,
            product_sale_item as i,
            product_sales as p
          SET s.product_total_quantity=s.product_total_quantity-i.quantity
          WHERE s.product_id=i.product_id AND
             i.product_sale_item_id=p.product_sales_item_id AND
             p.product_sales_id=NEW.product_sales_id;
         END IF;
     END
  //
  DELIMITER ;
  </code></pre>