replace missing value (NULL) as \N in your .txt file --- Gianluca Carnabuci <[EMAIL PROTECTED]> wrote: > Hi, > > I've been trying to import a huge .txt file into a > MySql table. In the .txt file, missing values are > recorded as empty cells (it might be that there's > some hidden character instead, but I wouldn't know > how to figure that out). When I LOAD DATA INFILE, > MySql writes the missing values as zeros, rather > than nulls. I can't UPDATE these zeros as nulls > after loading the data, because some of the data are > actually zeros in the original .txt file. > Do you have any suggestions? > > Gianluca > > --------------------------------------------------------------------- > 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 >
__________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com --------------------------------------------------------------------- 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