Learn SQL Database Programming

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", "book": "Learn SQL Programming"}

MySQL provides automatic validation of a JSON document and the optimal storage format. Storing JSON in a field with a type of JSON ensures you have well-formed JSON data. This is opposed to storing it in a character field, which offers ...