It's INSERT INTO with an ON CONFLICT clause. If the row doesn't exist, it's created. If it exists, the fields are updated in-place, which has much better performance than deleting the row and creating a new one.

Reply to this note

Please Login to reply.

Discussion

Excellent! Thank you, Updog. 👌