A Better Way to Store Address Data in a Database

 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-cheat-sheets/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign60
 Learn how to design an effective database and create it using SQL: https://databasestar.mykajabi.com/edd/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign60
An address is a physical location in the real world. It’s something we often need to store in our database, and there are several ways it can be done.
In this video, I’ll show a method that’s commonly used, highlight some issues that could happen using this method, and explain a better way of storing the data.
It’s not the “single best way to store addresses”, as there are other variations that you may want to use or prefer to use in your application, but it should help you when designing address fields.
We’ll also look at a couple of queries using the new design to get the data you might need.
Timestamps:
00:00 A common way to store addresses
00:42 Problems with addresses
02:17 The solution
04:51 SQL to create the table
05:48 One final tip - moving addresses