Forgotten sql problem

[Pisova]

SQL-fråga:

DELIMITER | CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` =3 AND `account` = OLD.`id` ;

MySQL sa: Dokumentation
#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 'DELIMITER |

CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`




I got this problem... anyone who could help me?

 

[Pisova]

SQL-fråga:

DELIMITER | CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` =3 AND `account` = OLD.`id` ;

MySQL sa: Dokumentation
#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 'DELIMITER |

CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`




I got this problem... anyone who could help me?

 

[MrSheen]

Ahhh.. You are going to need to import this script using the .exe and not PHPMYADMIN

 

[MrSheen]

Ahhh.. You are going to need to import this script using the .exe and not PHPMYADMIN

 

[shoffen]

ya I got the same problem as Pisova. I wollowed the guide as in the video, only thing I got a newer release of xampp
MrSheen thanks for trying to help, but it wasnt enough.

 

[shoffen]

ya I got the same problem as Pisova. I wollowed the guide as in the video, only thing I got a newer release of xampp
MrSheen thanks for trying to help, but it wasnt enough.