CIS 336 STUDY It's Your Life/cis336study.com CIS 336 STUDY It's Your Life/cis336study.com | Page 69

This will work : select unit _ price * 2 as NewPrice from items ; Deliverables
• Lab Report ( Answer Sheet ) containing both the studentcreated SQL command ( s ) for each exercise , and the output 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 ‟

This will work : select unit _ price * 2 as NewPrice from items ; Deliverables

• Lab Report ( Answer Sheet ) containing both the studentcreated SQL command ( s ) for each exercise , and the output 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 ‟