Hi Calvin,
Check out http://www.mysql.com/doc/L/O/LOAD_DATA.html and search for "Warnings". A paragraph probably of particular interest to you is: "Warnings occur under the same circumstances as when values are inserted via the INSERT statement (see section 6.4.3 INSERT Syntax), 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." > -----Original Message----- > From: Calvin Chin [mailto:[EMAIL PROTECTED]] > Sent: Sunday, October 28, 2001 9:08 PM > To: [EMAIL PROTECTED] > Subject: Help On Load Data File > Importance: High > > > Hi list member, > > I have a slight problem here. I am testing on the data > convertion from > text file into MySQL table. > > I am able to use the 'load data infile' command and insert > the data into > the table, however, with 1000 warnings. I don't know where I > can see the > warning messages ? > > Can you people help me to identify where MySQL store the > warning / error > messages generated? > > Thank you. > > Regards, > Calvin Chin > [EMAIL PROTECTED] > Ipmuda Berhad - Building materials for a better world ! > > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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
