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.