title: How to faster Mysql Insert with nullif?
body: <p>i am loading a CSV file through PHP and inserting into a temporary table, this is what my loading PHP script and MySQL query. </p>
  
  <pre><code>    $i=0;
      while (($data = fgetcsv($source, 1000, ",")) !== FALSE)
          {   
              if($i!=0) {
                  $column1=$data[0];
                  $column2=$data[1];
                  $column3=$data[2];
                  $column4=$data[3];
                  $column5=$data[4];
                  $column6=$data[5];
                  $query= "INSERT INTO temp_table(column1,column2,column3,column4,column5,column6,load_datetime)
      VALUES (nullif('$column1',''), nullif('$column2',''), nullif('$column3',''), nullif('$column4',''), nullif('$column5',''), nullif('$column6',''),now())";
                  mysql_query($query) or die(mysql_error());
              }
              $i++;
          }
  </code></pre>
  
  <p>and my CSV file has 25000 records, 
  this is a sample row from my CSV</p>
  
  <pre><code>        column1,column2,column3,column4,column5,column6
          ,,,13:57:18,,23:00:19
  </code></pre>
  
  <p>the problem i face is, it takes more than 10 minutes when i load the CSV and in between the page goes blank. 
  My PHP settings: upload_max_filesize: 100M post_max_size:100M max_execution_time:1000 max_input_time:1000.</p>
  
  <p>this my table detail</p>
  
  <pre><code>   CREATE TABLE temp_table (
         id int(11) NOT NULL,
         column1 time DEFAULT NULL,
         column2 time DEFAULT NULL,
         column3 time DEFAULT NULL,
         column4 time DEFAULT NULL,
         column5 time DEFAULT NULL,
         column6 time DEFAULT NULL,
         load_datetime datetime DEFAULT NULL
     ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  </code></pre>
  
  <p>and when i check the temp_table it has inserted around 8000 records. please help me with an approach to insert faster.</p>