[Check Point 12.1] Simple Queries in SQL – Chapter 12 Sumita Arora
Table of Contents
2. What is a datatype? Name some data types available in MySQL.
Solution:
A datatype specifies the type of data that can be stored in a database table’s columns. In MySQL, some common datatypes include:
- INT (integer)
- VARCHAR (variable-length string)
- TEXT (long text)
- DATE (date)
- DECIMAL (fixed-point decimal)
- FLOAT (floating-point number)