Learning the MySQL Data Types
Properly defining the fields in a table is important to the overall optimization of your database. You should use only the type and size of field you really need to use; don't define a field as 10 characters wide if you know you're only going to use 2 characters. These types of fields (or columns) are also referred to as data types, after the “type of data” you will be storing in those fields.
MySQL uses many different data types, broken into three categories: numeric, date and time, and string types. Pay close attention because defining the data type is more important than any other part of the table creation process.
Numeric Data Types
MySQL uses all the standard ANSI SQL numeric data types, so if you're coming ...