Reading in NA's into a column with Decimal datatype

2012-07-19 Thread Fred G
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

RE: Reading in NA's into a column with Decimal datatype

2012-07-19 Thread Rick James
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?