MySQL database best practice of choosing data types during database design


Below is list of prefered database types with lengths:

Email : varchar(254)

Domain: varchar(254)

Password: char(32)

Phone:varchar(16)

Financial Data : decimal(10,2)

Latitude: decimal(10,8)

Longitude: decimal(11,8)

Please write comment in case above information is incorrect. Please also share more fields in comment and I will update them here. This will help newbie developer.

 

Advertisements

Author: yogs174

I am programmer and entrepreneur and love innovative stuff. I like to work on different technologies with new tools.

1 thought on “MySQL database best practice of choosing data types during database design”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s