Ajuda Sql

[luizsa 0]

QUAndo vo importa a database da isso

 

Erro

 

consulta SQL:

 

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

 

Mensagens do MySQL : Documentação

#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

 

 

ALGUEM PODE ME AJUDA?