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 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!