#1064 when import a trigger

[Bartjuh1994]

Hi All,

 

When i add a trigger via SQL, i get this error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4

 

The trigger i've tried to import:

CREATE TRIGGER updatestock AFTER UPDATE ON ps_stock_available
FOR EACH ROW
BEGIN
UPDATE ps_product_shop SET active=0 WHERE id_product IN (SELECT id_product FROM ps_stock_available WHERE quantity=0);
UPDATE ps_product_shop SET active=1 WHERE id_product IN (SELECT id_product FROM ps_stock_available WHERE quantity>0);
END

i hope someone can help me.

Version MySQL: 5.5.21

[mac_gyver]

because the definition contains ; delimiters, you must temporarily change the delimiter to something else so that those characters can be stored in the definition instead of being treated as a delimiter. how are you importing this?

Edited May 23, 2013 by mac_gyver