Question: Hi, I am using MindTap in Cengage for DAT 380. I need help with the following problems: Problem 20.a Using MySQL, create a table named
Hi,
I am using MindTap in Cengage for DAT 380. I need help with the following problems:
Problem 20.a
Using MySQL, create a table named CUST_MYSQL with the same fields as in Problem 16, except, use the AUTO_INCREMENT feature for the CUST_NUM field.
Problem 20.b
Using MySQL, alter the table to populate the CUST_NUM field, beginning the increment with 2000.
Problem 20.c
Using MySQL, populate the CUST_LNAME, CUST_FNAME, and CUST_BALANCE fields with the following customers:
| CUST_LNAME | CUST_FNAME | CUST_BALANCE |
|---|---|---|
| Smith | Jeanne | 1050.11 |
| Ortega | Juan | 840.92 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
