MySQL determines that the specified condition data does not exist, does not exist, and then inserts

Toss a half-day finally put this to toss shun, but later found not to use unexpectedly ... Tragedy, but keep a record of deep memory.

Insert INTO table1 (field1, field2,field3) Select-Field1,?field2,?field3 from Temp

Where NOT EXISTS (select field1,field2,field3 from table1 where Field1=?field1 and Field2=?field2 and field3=?field3);

Table1 is your table name.

FIELD1,FIELD2,FIELD3 is the database field name

? FIELD1,?FIELD2,?FIELD3 is the data for the actual field

Temp is a temporary table name, and this can be random.

MySQL determines that the specified condition data does not exist, does not exist, and then inserts