Skip navigation links

MySQL Forums :: Events (Job Scheduler) :: How to read .txt in Event scheduler?


Advanced Search

Re: How to read .txt in Event scheduler?
Posted by: Devart Team ()
Date: May 19, 2011 12:51AM

The 'LOAD DATA INFILE' statement is not permitted in routines. But you could create a scheduler task (cron) in your OS and run mysql client with option --execute, e.g.- 

shell> mysql --user=user_name --password=your_password --execute="LOAD DATA INFILE..."

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/

Options: Reply•Quote


Subject Views Written By Posted
How to read .txt in Event scheduler? 3463 A Pole 05/18/2011 08:51AM
Re: How to read .txt in Event scheduler? 1382 Devart Team 05/19/2011 12:51AM
Re: How to read .txt in Event scheduler? 1206 stephen bond 06/30/2011 01:12PM
Re: How to read .txt in Event scheduler? 1310 Devart Team 07/01/2011 01:20AM
Re: How to read .txt in Event scheduler? 1135 stephen bond 07/01/2011 11:11AM
Re: How to read .txt in Event scheduler? 1088 Duncan Cox 08/11/2011 01:35AM


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

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.