Study guides, Class notes & Summaries
Looking for the best study guides, study notes and summaries about ? On this page you'll find 2 study documents about .
All 2 results
Sort by
-
ITS410: DATABASE MANAGEMENT COURSE
- Package deal • 4 items • 2022
-
- $15.49
- + learn more
Working with MySQL Table Joins
Changing a MySQL Table Structure
Performing an Advanced MySQL Query
Configuring a MySQL Database
-
Changing a MySQL Table Structure
- Other • 5 pages • 2022
- Available in package deal
-
- $8.29
- + learn more
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...
Fear of missing out? Then don’t!
Do you wonder why so many students wear nice clothes, have money to spare and enjoy tons of free time? Well, they sell on Stuvia! Imagine your study notes being downloaded a dozen times for $15 each. Every. Single. Day. Discover all about earning on Stuvia