[EMAIL PROTECTED] writes: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > database,sql,query,table > > If you just reply to this message, and include the entire text of it in the > reply, your reply will go through. However, you should > first review the text of the message to make sure it has something to do > with MySQL. You have written the following: > > > > Hi, > > I know the docs say that Warnings are not stored. > However, is there a way to enable some logging, > either in the server or locally (if using "load date LOCAL infile"), > that tells me which lines are bad ? I have a few 10k of lines, > and don't want to go over them individually... > > The mentioned "select into outfile" and diff'ing won't work either, > since float are printed with different precision, > giving me not a single identical line... > > Any ideas ? > > Yours, > Steffen > > /* excerpt from info file */ > > Warnings occur under the same circumstances as when values are inserted > via the `INSERT' statement (*note `INSERT': INSERT.), except that `LOAD > DATA INFILE' also generates warnings when there are too few or too many > fields in the input row. The warnings are not stored anywhere; the > number of warnings can only be used as an indication if everything went > well. If you get warnings and want to know exactly why you got them, > one way to do this is to use `SELECT ... INTO OUTFILE' into another > file and compare this to your original input file. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
