Make a table called status selects and groups all status values from my_contacts and stores the unique
Question:
Make a table called status selects and groups all status values from my_contacts and stores the unique values in the new table. 2. (If you need to) alter the new status table to contain a primary key - if you did this in the last step you can skip to step 3. 3. Use an UPDATE statement to make the my_contacts.status column to contain the ID values from the status table (rather than the status values as provided) 4. After step 3 is successful, the my_contacts.status field will now contain integer values rather than text values. Alter the column to store integer values, decide whether you want to rename the column, then choose whether a MODIFY or CHANGE statement is more appropriate. In your report, justify your choice of MODIFY or CHANGE.
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last