Updating and inserting records in MySql

[robjones2]

Quite new to using MySQL with VB.

I am using UPDATE with a unique key to update existing records, but I want it to also insert new records that dont exist.

Whats the easiest way to do this?

[coopster]

INSERT ... ON DUPLICATE KEY UPDATE ... [dev.mysql.com] often works well in this situation.