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.
IMDb.com, one of the world's top web sites, started as a Usenet posting by Col Needham. He created a list of actresses with beautiful eyes called "Those Eyes". [more...]