ITS 410 CSU Global SQL Command JSON Query to Probe Office Data Project

I’m working on a mysql question and need an explanation to help me understand better.

Using the “classicmodels” database you installed in Module 1 and your MySQL Workbench, add a JSON field named “customers_contacts” to the “customers” table with the following keys:

• customerNumber,
• contactLastName, and
• contactFirstName.

Write a SQL statement to insert at least three values for the “customers_contacts” field. Use data from the customers table. If you need a hint on how to write the SQL insert statement for a JSON data type, refer to the examples in http://www.mysqltutorial.org/mysql-json/ (Links to an external site.).

Submit a 1-page Microsoft Word document that shows the following:

• The SQL command you used to insert data into the “customers_contacts” field and a listing of rows from the customer table where the “customers_contacts” column has data.
• What is JSON? What are the advantages of using JSON as a field type? What are the disadvantages of using JSON as a field type?