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.
