Greetings all,
I am knew to the the world of SQL and am interested in putting data into a
database that I have created. The data will be in the form of a tab
delimited text file that will generated several times a day with different
data. What I would like to do is use the LOAD LOCAL DATA INFILE "xxx.txt"
INTO TABLE tablename; to do this from windows scheduler or CRON to schedule
the job to be ran as needed. I know the SQL command works fine. I'm using it
on another database, but I am manually entering it in. On this project, I
won't have that kind of time to manually type it or open the MySQL Query
Brower and re-run the command.
Any help would be greatly appreciated, but remember I am still real new to
this.
Thanks,
eric
