تقييمات الطلاب
( 5 من 5 )
١ تقييمات
فيديو شرح The Best Way to Store Phone Numbers in an SQL Database ضمن كورس تصميم قواعد البيانات (ERD) شرح قناة Database Star، الفديو رقم 17 مجانى معتمد اونلاين
Get my Database Design Guides to many different sample databases: https://www.databasestar.com/dbdesign/?utm_sourceviddesc&utm_mediumyoutube&utm_campaign72
Turn your idea into a real database: 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