From: Fred G Date: July 19 2012 8:42pm Subject: Reading in NA's into a column with Decimal datatype List-Archive: http://lists.mysql.com/mysql/227854 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=e89a8fb20780be865f04c534d216 --e89a8fb20780be865f04c534d216 Content-Type: text/plain; charset=ISO-8859-1 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. --e89a8fb20780be865f04c534d216--