The Best Way to Store Phone Numbers in an SQL Database

 Get my Database Design Guides to many different sample databases: https://www.databasestar.com/dbdesign/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign72
 Learn how to design an effective database and create it using SQL: https://databasestar.mykajabi.com/edd/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign72
Phone numbers are a common field to store in a database. However, storing them as integers can cause problems.
In this video, I'll demonstrate an example of storing a phone number as an integer, explain a problem, propose a better way to store phone numbers, why it works, and show an example.
You'll also learn about formatting of phone numbers and my recommendation for that.
TIMESTAMPS:
00:00 - Introduction
00:42 - Storing a phone number as an integer
02:32 - What is a phone number?
03:26 - Another way
04:56 - Formatting phone numbers