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
2105
June 12, 2015 07:02AM
1161
June 12, 2015 04:30PM
1199
June 16, 2015 01:01AM
Re: lire un fichier externe
1181
June 16, 2015 01:10AM
1068
June 16, 2015 02:25AM
937
June 16, 2015 02:35AM
944
June 16, 2015 02:37AM
1303
June 16, 2015 03:13AM
1029
June 16, 2015 03:28AM
1011
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.