title: MySQL direct INSERT INTO with WHERE clause
body: <p>I tried googling for this issue but only find how to do it using two tables, as follows,</p>
  
  <pre><code>INSERT INTO tbl_member
  SELECT Field1,Field2,Field3,... 
  FROM temp_table
  WHERE NOT EXISTS(SELECT * 
           FROM tbl_member 
           WHERE (temp_table.Field1=tbl_member.Field1 and
                 temp_table.Field2=tbl_member.Field2...etc.)
          )
  </code></pre>
  
  <p>This worked for one scenario,But now my interest is to upload data directly from the program itself without using two tables. What i want is to upload the data which is not in the table. The sql i had in my head was like the following,</p>
  
  <pre><code>INSERT INTO tbl_member (SensorIdValue, DataTimeValue, DataInValue, IncompleteValue, SpiValue, InfoValue)
  VALUES ('Sensor.org', '20121017150103', 'eth0','','','')
  WHERE (SensorIdValue != 'Sensor.org'AND DataTimeValue != '20121017150103'AND DataInValue != 'eth0'AND IncompleteValue != ''AND SpiValue != ''AND InfoValue != '');
  </code></pre>
  
  <p>But it's wrong.. may i know the proper way of doing it please, Thank you very much :)</p>