Erreur
Il semble qu'il y ait une erreur dans votre requête SQL. Le message ci-bas peut vous aider à en trouver la cause.
ERROR: Ponctuation invalide @ 66
STR: //
SQL: CREATE TRIGGER trg_un AFTER UPDATE ON tb1
FOR EACH ROW
DELIMITER//
BEGIN
UPDATE tb2 INNER JOIN tb1 ON tb1.id = tb2.id SET tb2.nom = tb1.nom ;CREATE TRIGGER trg_un AFTER UPDATE ON tb1
FOR EACH ROW
DELIMITER//
BEGIN
UPDATE tb2 INNER JOIN tb1 ON tb1.id = tb2.id SET tb2.nom = tb1.nom ;CREATE TRIGGER trg_un AFTER UPDATE ON tb1
FOR EACH ROW
DELIMITER//
BEGIN
UPDATE tb2 INNER JOIN tb1 ON tb1.id = tb2.id SET tb2.nom = tb1.nom ;
requête SQL:
CREATE TRIGGER trg_un AFTER UPDATE ON tb1 FOR EACH ROW DELIMITER// BEGIN UPDATE tb2 INNER JOIN tb1 ON tb1.id = tb2.id SET tb2.nom = tb1.nom ;
MySQL a répondu

ocumentation
#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 '//
BEGIN
UPDATE tb2 INNER JOIN tb1 ON tb1.id = tb2.id SET tb2.nom = tb1.nom' at line 3
Partager