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:bayespoker...@gmail.com] > Sent: Thursday, July 19, 2012 1:43 PM > To: mysql@lists.mysql.com > 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
