Sams Teach Yourself MySQL in 21 Days, Second Edition

Summary

Today, you took a close look at MySQL's data and column types. You looked at integer, floating-point, binary, text, date, and time column types. You examined what they can store and how data is inserted into and retrieved from them. You learned about ENUM and SET, column types that can take values only from a declared valid list.

You also learned about some special kinds of columns, such as AUTO_INCREMENT for creating sequences of integers and TIMESTAMP for automatically inserting the date and time.