title: Ignoring all null records while inserting data in mysql table
body: <p>I created a table(tbldemo) with 22 columns using a "create table" statement in mysql, when trying to insert the data from a .csv file using "Load data infile" statement it's giving me the error, Now how do I ignore the rows whose entire row is null or empty </p>
  
  <pre><code> Error Code: 1261. Row 11513 doesn't contain data for all columns
  </code></pre>
  
  <p>this is what I used to load the data from .csv</p>
  
  <pre><code>LOAD DATA INFILE 'D:/Singapore/rau_sales_order.csv' INTO TABLE tbldemo
   FIELDS TERMINATED BY ',' 
  ENCLOSED BY '"'  LINES TERMINATED BY '\r\n'
   IGNORE 1 LINES;
  </code></pre>
  
  <p>I don't want to open .csv file and clean the data from the file by filtering it for null, instead want to do it directly by query.Is there any way to acheive this?. Thanks in advance.</p>