title: MySql stored procedure in workbench
body: <p>I am using MySQL benchmark. I have to create a table and write a procedure to read 10 from textfilnd load them to the created table.</p>
  
  <p>I used the query:</p>
  
  <pre><code>use test; 
  DELIMITER $$ 
  
  CREATE DEFINER=`root`@`localhost` PROCEDURE `p_table`() 
  BEGIN 
  LOAD DATA LOCAL INFILE "D:/tablevalue.txt" 
  INTO TABLE new_table 
  FIELDS TERMINATED BY ',' 
  LINES TERMINATED BY '\n'; 
  
  END $$ 
  
  DELIMITER ; 
  </code></pre>
  
  <p>But error like load data is not allowed in stored procedure, and then I used the query. </p>
  
  <pre><code>use test; 
  drop procedure if exists `proctable`; 
  DELIMITER $$ 
  
  create definer =`root`@`localhost` procedure `proctable`() 
  begin 
  
  do sys_exec(concat('perl LOAD_DATA_INFILE.pl test.new_table ', 'D:\tablevalue.txt')); 
  
  end $$ 
  
  DELIMITER ; 
  </code></pre>
  
  <p>But data is not uploading from the file to the table. </p>
  
  <p>If is there any other option let me know</p>