Chapter 5. Data Types

This chapter discusses data types for representing information in MySQL. It covers the following exam topics:

• An overview of available data types

• Numeric data types

• The BIT data type

• String data types

• Temporal (date and time) data types

• Attributes that modify how columns are handled

• The AUTO_INCREMENT attribute for sequence generation

• Controlling how MySQL handles missing or invalid input data values