Use This One SQL Command to Insert OR Update a Table
📝 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-...
🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql...
If you need to import data, you'll likely want to either update existing rows or insert new rows depending on if the row exists or not.
There's a command in SQL that lets you do exactly this.
In this video, I'll explain what the issue is, explain the command that can be used, and show you examples in several SQL vendors.
⏱ TIMESTAMPS:
00:00 - The problem
01:02 - The command we can use
01:49 - How to do it (Postgres)
05:25 - Another example
07:00 - Oracle
07:47 - SQL Server
🔗 VIDEO LINKS:
SQL scripts used in this video: https://github.com/bbrumm/databasesta...
