[DataBase] Error in DataBase

[Carinha]

Hello guys, I have a problem in my DB, when I import it in XAMPP it's this error:

Error
SQL query:

DELIMITER | CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON  `accounts` FOR EACH ROW BEGIN DELETE FROM  `bans` WHERE  `type` IN ( 3, 4 ) AND  `value` = OLD.`id` ;


Mensagens do MySQL : 

#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`
FOR ' at line 1

Does someone with more experience could help me?

sorry my bad english!

 

[psychomen]

Try to put the DELIMITER command in a different line:

DELIMITER |
CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON  `accounts` FOR EACH ROW BEGIN DELETE FROM  `bans` WHERE  `type` IN ( 3, 4 ) AND  `value` = OLD.`id`;