Procurar em : Tópicos Encerrados
Tópico : Pack Azure
Respostas : 19
Vistos : 15269
Pack Azure em 20.05.15 18:39
Quando vou importar as tabelas corretas dá o seguinte erro
consulta SQL:
DELIMITER $$--
-- Eventos
--
CREATE DEFINER = `root`@`localhost` EVENT `daily_pet_respect_points` ON SCHEDULE EVERY24 HOUR STARTS '2015-02-10 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO UPDATE users_stats SET daily_pet_respect_points =5 WHERE daily_pet_respect_points = 0$$
Mensagens do MySQL : Documentação
#1537 - Event 'daily_pet_respect_points' already exists
consulta SQL:
DELIMITER $$--
-- Eventos
--
CREATE DEFINER = `root`@`localhost` EVENT `daily_pet_respect_points` ON SCHEDULE EVERY24 HOUR STARTS '2015-02-10 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO UPDATE users_stats SET daily_pet_respect_points =5 WHERE daily_pet_respect_points = 0$$
Mensagens do MySQL : Documentação
#1537 - Event 'daily_pet_respect_points' already exists