Load file errors

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

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

Quoted text here. Click to load it

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
an error.

Bill K.

Site Timeline