INSERT w- IF NOT EXISTS

[admoore]

Query as follows produces error:

INSERT INTO new_table(id) IF NOT EXISTS
SELECT phone as id FROM `orig_table` WHERE disposition = 'DNC'

newtable(id) is primary key and I wish to prevent INSERT from failing due to duplicate records in SELECT query.

Also, is there a way to include a static value to a field in the new_table, i.e. code=staticvalue as part of the query syntax?

Hopefully this is s†a†ed clearly.

TIA,

-Allen M

 

[admoore]

Went w- a JOIN instead...