Do you have a question? Post it now! No Registration Necessary. Now with pictures!
February 27, 2006, 2:24 pm
rate this thread
I am looking into writing many sql statements to a file and then
executing those all at once. I am using perl in windows to create the
insert statements and then need to load the data into a Unix Mysql DB.
Would like to do the insert from the windows side using perl and ODBC,
but it maybe much faster to do from Unix that it would be the better
way to go.
What command would I use and if a single statement were wrong, how
would the DB or script respond.
Thank you for any guidance.
Re: Load file errors
The 'mysql' command-line tool is the best for this.
Specifically, read these pages:
There is also a "-f" option that causes the execution to continue if any SQL
errors are encountered. The default behavior is to abort when it receives
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum