What is an UPSERT and how to do them in MySQL, Postgres, & CockroachDB
In this video we explain what an upsert is and how to do upserts in MySQL, Postgres, and CockroachDB. If you want to learn more about when to use Upserts check out this blog on the subject: https://www.cockroachlabs.com/blog/sq...
0:00 What is an upsert?
1:08 UPSERT examples in CockroachDB
1:37 Upsert syntax in other databases
1:51 Upserts in MySQL
2:07 Upserts in PostgreSQL
2:28 UPSERT vs. INSERT ... ON CONFLICT
3:09 Conclusion
#CockroachDB #DistributedSQL #sqldeveloper
