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
1722
June 12, 2015 07:02AM
967
June 12, 2015 04:30PM
997
June 16, 2015 01:01AM
Re: lire un fichier externe
955
June 16, 2015 01:10AM
877
June 16, 2015 02:25AM
764
June 16, 2015 02:35AM
755
June 16, 2015 02:37AM
1031
June 16, 2015 03:13AM
854
June 16, 2015 03:28AM
813
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.