What do you need to know to complete the FIRST step in the process of creating a new table using data from an existing table, called CANDY, in MySQL?
A) the number of rows and columns in the existing table
B) the primary key value for each row in the table of existing data
C) the columns from CANDY that you want to include and their characteristics
D) the rows from CANDY that you want to include in the new table

Question

Quizplus · Accepted Answer

To create a new table using data from an existing table, the first step involves knowing which columns from the existing table (in this case, CANDY) you want to include in the new table and understanding their characteristics (data types, constraints, etc.). This information is crucial for defining the structure of the new table.

What Do You Need to Know to Complete the FIRST