MySQL Forums
Forum List  »  French

Re: lire un fichier externe
Posted by: Jean Molliné
Date: June 16, 2015 01:10AM

Salut,
il y a une erreur dans la création de l'EVENT :

DELIMITER $$
GRANT EVENT ON pcsecurite4.* TO root@10.1.21.144$$
CREATE EVENT ev_kill_massprocess_01
ON SCHEDULE
EVERY 1 MINUTE STARTS CURRENT_TIMESTAMP ON COMPLETION PRESERVE ENABLE
DO
CALL sp_select_pcsecurite4_massprocess_id()$$ <<==== Le délimiteur utilisé ici met un terme à la création
SOURCE C:/toto/killProcess.txt
DELIMITER ;

Ça devrait dont normalement être :

DELIMITER $$

GRANT EVENT ON pcsecurite4.* TO root@10.1.21.144 $$

CREATE EVENT ev_kill_massprocess_01
  ON SCHEDULE
  EVERY 1 MINUTE STARTS CURRENT_TIMESTAMP ON COMPLETION PRESERVE ENABLE
  DO
    BEGIN
      CALL sp_select_pcsecurite4_massprocess_id();
      SOURCE C:/toto/killProcess.txt
    END
$$

DELIMITER ;

______________________________________________________________
Une question bien formulée, c'est un problème bien compris : ça représente déjà les 3/4 de la réponse ;)

Options: ReplyQuote


Subject
Views
Written By
Posted
1622
June 12, 2015 07:02AM
902
June 12, 2015 04:30PM
920
June 16, 2015 01:01AM
Re: lire un fichier externe
890
June 16, 2015 01:10AM
821
June 16, 2015 02:25AM
709
June 16, 2015 02:35AM
703
June 16, 2015 02:37AM
960
June 16, 2015 03:13AM
797
June 16, 2015 03:28AM
750
June 16, 2015 04:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.