On Tue, Feb 26, 2002 at 12:03:25PM -0600, Paul DuBois wrote: > >it set the integer columns to 0 if they were blank in the text file. > >How can I make it set those to NULL instead? > > You'll have to preprocess the file to convert empty fields to \N.
Damn, that's what I thought. I guess I'll have to do that for now; thanks for the perl code. I think that it would have made sense for MySQL to treat empty fields as NULL when importing into a numeric column. (Right now, the empty field causes a warning anyway since it converts it to 0.) Is there a place where I can put this in as a feature request (or is there a good reason that it shouldn't do this)? --------------------------------------------------------------------- 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
