Search the Community
Showing results for tags '1064'.
Found 1 result
#1064 when import a trigger
Bartjuh1994 posted a topic in MySQL HelpHi 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