MySQL supports some other types of data beyond string, numeric, and date and time data types. The following sections cover these data types in more detail, including JSON and spatial data types.
Understanding other data types
Other data types in MySQL
We will briefly cover some other data types in MySQL. These will be high-level explanations since we won't be using these types throughout the book, but this will show you that other types do exist and may be in use in databases you are using:
- JSON: This data type holds values in the native JSON (JavaScript Object Notation) language. Use curly braces to surround JSON key/value pairs. Here is an example of JSON syntax:
{"Author":"Josephine Bush", ...