List:General Discussion« Previous MessageNext Message »
From:Rick James Date:July 19 2012 8:48pm
Subject:RE: Reading in NA's into a column with Decimal datatype
View as plain text  
The online doc for LOAD DATA gives an example of how to read the data into an @variable,
then do arithmetic (etc) on it before putting it into the 'real' field.

In your case, some something like
   @foo, BF1 14:46:20 ~$ yinst self-update -br yinst7test
Password: 
yinst:  Need help? http://twiki.corp.yahoo.com/view/DevTools/YinstProb
yinst: Bad version: -br
yinst: yinst-7.112.5808  dec_field = IF(@foo = 'NA', NULL, @foo)

> -----Original Message-----
> From: Fred G [mailto:bayespokerguy@stripped]
> Sent: Thursday, July 19, 2012 1:43 PM
> To: mysql@stripped
> Subject: Reading in NA's into a column with Decimal datatype
> 
> Hi guys--
> 
> I am having some trouble importing a csv file correctly as a table in
> my new database.  In particular, there are 4 NA's in a column with
> 10,000+ other rows that have decimal values for that column.
> 
> How can I get MySQL to read in these "NA's" as some sort of null that
> is accepted by the decimal datatype? I've read a few posts about this
> already, but nothing has worked for me yet...
> 
> Much thanks in advance.
Thread
Reading in NA's into a column with Decimal datatypeFred G19 Jul
  • RE: Reading in NA's into a column with Decimal datatypeRick James19 Jul