|List:||General Discussion||« Previous MessageNext Message »|
|From:||Fred G||Date:||July 19 2012 8:42pm|
|Subject:||Reading in NA's into a column with Decimal datatype|
|View as plain text|
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.
|• Reading in NA's into a column with Decimal datatype||Fred G||19 Jul|
|• RE: Reading in NA's into a column with Decimal datatype||Rick James||19 Jul|