MySQL Best Data Types For Common Types Of Data

Primary Key : INT UNSIGNED

- About 4.3 billion available IDs. Going unsigned gives you the extra 2 billion.

Phone Number : VARCHAR

- Phone numbers are identifiers that happen to use digits.
- See this post.

Price : FLOAT

- FLOATs will be calculated natively by the CPU rather than by the server.


This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>