Question: Download the classicmodels database from the following MySQL website: http://www.mysqltutorial.org/mysql-sample-database.aspx (Links to an external site.)Links to an external site. Using the classicmodels database you installed

Download the classicmodels database from the following MySQL website: http://www.mysqltutorial.org/mysql-sample-database.aspx (Links to an external site.)Links to an external site.

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.)Links to an external site..

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!