CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | Page 68

showing the results obtained. Be sure your name is on the
file.
LAB STEPS: Complete each of the exercises below.
1. Use an ALTER TABLE statement to update the
customers table so that the Primary Key field is an autoincrement field, then create TWO insert statements to test
proper operation, using your own first and last name for one
(and a name of your choice for the second one), and any data
you care to imagine for the remaining fields.
IMPORTANT NOTE: When using a LOCAL copy of
MySQL, if you attempt to simply issue the ALTER TABLE
command you have composed by itself, you should receive
an error similar to the following (try it for yourself!).
ERROR 1833: Cannot change column „customer_id‟: used
in a foreign key constraint „orders_fk_customers‟ of table
„om.orders‟
(Note – EDUPE will not give this error message, however
you should still follow the CORRECT procedure as
discussed here to complete this problem).
The reason for this is that you are attempting to alter data in
one column that has a defined PK:FK relationship to a field
in another table. Referential Integrity rules prevent this. So,
how do you resolve such a problem?