Re: Insert if exists

[Peter Brawley]

> Would the record still be unique if I run the script?

A primary or unique index on all table columns would be unmanageable if there are more than three or so columns. Decide which address columns are crucial for uniquenesss and make those the primary key, or a unique key if there is already a surrogate (auto)_increment) primary key.

For remaining columns, if nulls are allowed it's more efficient to decalre them default null than to manage code that sets them to null.