Hello.
>..e, but I am manually entering it in.
Use mysql command line client. You may pass SQL statements as the
command line options or execute them from the file (i.e mysql -e
"sql_statement" or mysql < sql_file). See:
http://dev.mysql.com/doc/mysql/en/mysql.html
Eric Mynes <sixxd6@stripped> wrote:
>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
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
