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.
At one time, Coca-Cola had an online music store - myCokeMusic.com. It ceased operation on 31st July 2006. Even though they had myCokeMusic.com music store, Coca-Cola still did a promotion that involved Apple iTunes. In July 2005, a free iTunes song was given away with every 32 US fl oz Slurpee bought from 7-Eleven. [more...]