On Fri, 2002-03-08 at 14:19, [EMAIL PROTECTED] wrote: > 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: > > sql,query > > 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. Just typing the word MySQL once will be sufficient, for example. > > You have written the following: > > I've noticed the hard way that there is more to loading data exported > from informix than just: > > LOAD DATA LOCAL INFILE "speci02695.unl" > INTO TABLE specimens FIELDS TERMINATED BY '|'; > > I have all of the columns that are INTEGER that were NULL in informix, > now have the value 0. > > I have several export files that are over a gig. I do not want to > preparse the file with perl to make all of the NULL values \N, so what > can I do? > > Thanks.
I really think that you need to check the spam-o-meter for this kind of query. -- Brian Millett Enterprise Consulting Group "Shifts in paradigms (314) 205-9030 often cause nose bleeds." [EMAIL PROTECTED] Greg Glenn --------------------------------------------------------------------- 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