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 <[EMAIL PROTECTED]> 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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
