INTEGER- This stores whole numbers, both positive and negative. Some examples are 2, 45, -16 and 23989. In our example, the age category could have been integer.
FLOAT- This stores numbers when you need to use decimals. Some examples would be 2.5, -.664, 43.8882, or 10.00001.
DATETIME- This stores a date and time in the format YYYY-MM-DD HH:MM:SS
VARCHAR- This stores a limited amount of text or single characters. In our example, the name column could have been varcar (short for variable character)
BLOB- This stores binary data other than text, for example file uploads.