Changing a MySQL Table Structure
Option #2: Changing a MySQL Table Structure 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 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?
École, étude et sujet
- Établissement
- ITS410 Database Management
- Cours
- ITS410 Database Management
Infos sur le Document
- Publié le
- 16 février 2022
- Nombre de pages
- 5
- Écrit en
- 2021/2022
- Type
- Autre
- Personne
- Inconnu
Sujets
-
programming
-
its 410 critical thinking 2
-
its410 database management
-
using the classicmodels database you installed in module 1 and your mysql workbench
-
add a json field named customersc
Document également disponible en groupe