By Volume4
via sql.dzone.com
Published: Dec 02 2008 / 09:01
One of the biggest mistakes of today's fledgling MySQL programmers is their field type definitions, also known as data type or column type. Many are too quick to set up their tables, flying through the different options without giving it much thought. The time you spend setting up your tables will save you from many headaches later on down the road.
-
REST & WOA Wiki
-
Using various javascript libraries to create pie chart: Bluff, Flot, GRaphael, Plotkit, Sparklines
-
A JPEG Encoder for JavaScript
-
Android operating system - Bless for hardware manufacturers and mess for software developers
-
Is Your Manager Responsible for Your Career?
-
Using JSF 2 with Google App Engine
Comments
geetee replied ago:
I wouldn't store a phone number as an integer. Leading zeroes will be chopped off.
nightwind replied ago:
"It is important to note that because of the way DOUBLE works it should never be used for precise values such as currency."
Voted up even just for that one hint. Can't be said often enough.
Voters For This Link (14)
Voters Against This Link (2)