title: LOAD DATA is not allowed in stored procedures
body: <p>I have a case to import data into mysql automatically every 6pm. data to be imported is "data.txt".</p>
  
  <p>I created in mysql like this:</p>
  
  <pre><code>CREATE EVENT EVENT_NAME
  ON SCHEDULE EVERY '18: 00:00 'DAY
  DO
  LOAD DATA LOCAL INFILE 'd :/ data.txt'
  INTO TABLE table_name
  FIELDS terminated BY ','
  LINES terminated BY '\ n'
  (atribut1, atribut2, atribut3);
  </code></pre>
  
  <p>if i just write like this</p>
  
  <pre><code>LOAD DATA LOCAL INFILE 'd :/ data.txt'
  INTO TABLE table_name
  FIELDS terminated BY ','
  LINES terminated BY '\ n'
  (atribut1, atribut2, atribut3);
  </code></pre>
  
  <p>the query was successfully executed</p>
  
  <p>but if i write the code like a fist code instead there is an error "LOAD DATA is not allowed in stored procedures". is it really like that? if it's like that how do i to handle such cases? thanks in advance
  sorry for my bad english</p>