The three major types of column types used in MySQL are
Choosing a column data type is very important in order to achieve speed, effective storage and retrieval. Hence, I’ve dedicated two sessions to this topic. Now, I’ll be touching only the surface; for a thorough explanation refer the resources in What Next? session.
In addition to int (Integer data type), MySQL also has provision for floating-point and double precision numbers. Each integer type can take also be UNSIGNED and/or AUTO_INCREMENT.
Starting out in 1990 as unix shell search scripts and four lists (of actors, actresses, dead actors/actresses and directors), IMDb was made into an independent web site developed and maintained by Col Needham and his friends. [more...]