Postado Abril 26, 2015 10 anos Alguem sabe como corrigir esse erro ao tentar importar essas 2 tabelas? CREATE TRIGGER `oncreate_players` AFTER INSERT ON `players` FOR EACH ROW BEGIN INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10); INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10); CREATE TRIGGER `ondelete_players` BEFORE DELETE ON `players` FOR EACH ROW BEGIN DELETE FROM `account_viplist` WHERE `player_id` = OLD.`id`; DELETE FROM `player_viplist` WHERE `player_id` = OLD.`id` OR `vip_id` = OLD.`id`; DELETE FROM `player_storage` WHERE `player_id` = OLD.`id`; DELETE FROM `player_skills` WHERE `player_id` = OLD.`id`; DELETE FROM `player_items` WHERE `player_id` = OLD.`id`; DELETE FROM `player_depotitems` WHERE `player_id` = OLD.`id`; DELETE FROM `player_spells` WHERE `player_id` = OLD.`id`; DELETE FROM `player_killers` WHERE `player_id` = OLD.`id`; DELETE FROM `player_deaths` WHERE `player_id` = OLD.`id`; DELETE FROM `guild_invites` WHERE `player_id` = OLD.`id`; DELETE FROM `bans` WHERE `type` IN (2, 5) AND `value` = OLD.`id`; UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`; Quando executo elas tenho esses erros: consulta SQL: CREATE TRIGGER `oncreate_players` AFTER INSERT ON `players` FOR EACH ROW BEGIN INSERT INTO `player_skills` ( `player_id` , `skillid` , `value` ) VALUES (NEW.`id` , 0, 10); 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 '' at line 6 Erro consulta SQL: CREATE TRIGGER `ondelete_players` BEFORE DELETE ON `players` FOR EACH ROW BEGIN DELETE FROM `account_viplist` WHERE `player_id` = 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 '' at line 6 Ja executei um drop: DROP TRIGGER IF EXISTS `oncreate_players`; DROP TRIGGER IF EXISTS `ondelete_players`; Uso mysql (MySQL: 5.0.51a) Alguem sabe oque ta errado? Editado Abril 26, 2015 10 anos por Coul (veja o histórico de edições)
Participe da conversa
Você pode postar agora e se cadastrar mais tarde. Se você tem uma conta, faça o login para postar com sua conta.