erro no importar phpadmin

[guititan 0]

alguem poderia me dar uma luz nesse erro do meu ot quando carrego no phpadmin no importar aparece ese erro alguem poderia me ajudar

 

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 :

 

#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

[Thiago Thamiel 0]

alguem poderia me dar uma luz nesse erro do meu ot quando carrego no phpadmin no importar aparece ese erro alguem poderia me ajudar

 

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 :

 

#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

Cara posta no forum de MySql .. http://forum.imasters.com.br/public/style_emoticons/default/natal_wink.gif

[Mário Monteiro 179]

Tópico Movido

 

Origem: SQL Server http://forum.imasters.com.br/public/style_emoticons/default/seta.gif Destino: MySQL