title: Importing NULL for decimal type MySql
body: <p>I have a table with the following schema</p>
  
  <pre><code>+-------------+--------------+------+-----+---------+-------+
  | Field       | Type         | Null | Key | Default | Extra |
  +-------------+--------------+------+-----+---------+-------+
  | NDB_No      | char(5)      | NO   | PRI | NULL    |       |
  | FdGrp_Cd    | char(4)      | NO   | MUL | NULL    |       |
  | Long_Desc   | char(200)    | NO   |     | NULL    |       |
  | Shrt_Desc   | char(60)     | NO   |     | NULL    |       |
  | ComName     | char(100)    | YES  |     | NULL    |       |
  | ManufacName | char(65)     | YES  |     | NULL    |       |
  | Survey      | char(1)      | YES  |     | NULL    |       |
  | Ref_desc    | char(135)    | YES  |     | NULL    |       |
  | Refuse      | decimal(2,0) | YES  |     | NULL    |       |
  | SciName     | char(65)     | YES  |     | NULL    |       |
  | N_Factor    | decimal(4,2) | YES  |     | NULL    |       |
  | Pro_Factor  | decimal(4,2) | YES  |     | NULL    |       |
  | Fat_Factor  | decimal(4,2) | YES  |     | NULL    |       |
  | CHO_Factor  | decimal(4,2) | YES  |     | NULL    |       |
  +-------------+--------------+------+-----+---------+-------+
  </code></pre>
  
  <p>When trying to import this line</p>
  
  <pre><code>01002^0100^Butter, whipped, with salt^BUTTER,WHIPPED,W/ SALT^NULL^NULL^Y^NULL^0^NULL^6.38^NULL^NULL^NULL
  </code></pre>
  
  <p>I'm met with an error</p>
  
  <pre><code>1366 Incorrect decimal value: 'NULL' for column 'Pro_Factor' 
  1366 Incorrect decimal value: 'NULL' for column 'Fat_Factor' 
  1366 Incorrect decimal value: 'NULL' for column 'CHO_Factor' 
  </code></pre>
  
  <p>And the data is imported as <code>0.00</code></p>
  
  <pre><code>'01002', '0100', 'Butter, whipped, with salt', 'BUTTER,WHIPPED,W/ SALT', 'NULL', 'NULL', 'Y', 'NULL', '0', 'NULL', '6.38', '0.00', '0.00', '0.00'
  </code></pre>
  
  <p>Currently, I'm using MySQLWorkbench to import the data from a local file</p>
  
  <pre><code>LOAD DATA LOCAL INFILE 'FOOD_DES.txt' 
  INTO TABLE usda_sr28.FOOD_DES
  FIELDS TERMINATED BY '^'
  LINES TERMINATED BY '\n';
  </code></pre>