MySQL direct INSERT INTO with WHERE clause

Question

I tried googling for this issue but only find how to do it using two tables  as follows   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               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   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           But it s wrong   may i know the proper way of doing it please  Thank you very much

User · Accepted Answer

INSERT syntax cannot have WHERE clause  The only time you will find INSERT has WHERE clause is when you are using INSERT INTO   SELECT statement   The first syntax is already correct

User · Answer

Example of how to perform a INSERT INTO SELECT with a WHERE clause   INSERT INTO  test2  id  SELECT id FROM  test1 WHERE id  gt  2

User · Answer

The INSERT INTO Statement   The INSERT INTO statement is used to insert a new row in a table    SQL INSERT INTO Syntax   It is possible to write the INSERT INTO statement in two forms   The first form doesn t specify the column names where the data will be inserted  only their values   INSERT INTO table name VALUES  value1  value2  value3        The second form specifies both the column names and the values to be inserted   INSERT INTO table name  column1  column2  column3      VALUES  value1  value2  value3

User · Answer

If I understand the goal is to insert a new record to a table but if the data is already on the table  skip it  Here is my answer   INSERT INTO tbl member   Field1 Field2 Field3       SELECT a Field1 a Field2 a Field3      FROM  SELECT Field1    NewValueField1   Field2    NewValueField2   Field3    NewValueField3        AS a  LEFT JOIN tbl member AS b  ON a Field1   b Field1  WHERE b Field1 IS NULL   The record to be inserted is in the new value fields

User · Answer

you can use UPDATE command   UPDATE table name SET name  name  email  email  phone  phone WHERE client id  client id

User · Answer

INSERT syntax cannot have WHERE but you can use UPDATE  The syntax is as follows  UPDATE table name  SET column1   value1  column2   value2       WHERE condition

[mysql] MySQL direct INSERT INTO with WHERE clause

Examples related to mysql

Examples related to insert

Examples related to where-clause