Learn SQL Database Programming

Summary

In this chapter, we covered what data types are and how they are used. We learned about specific data types and what data can be stored in each. Data types include string, numeric, date and time, and other types such as JSON and spatial types. String data types include char and varchar, binary and varbinary, blob, enum, set, and text. Numeric data types include bit, int, float, double, and decimal. Date and time data types include date, time, datetime, timestamp, and year. We learned from the perspective of MySQL data types, but where there were differences versus Oracle, PostgreSQL, and SQL Server, those differences were noted.

We also went through some examples of types and values of data to see examples of how to assign them correctly ...