CIS 336 STUDY Great Stories/cis336study.com CIS 336 STUDY Great Stories/cis336study.com | Page 75

It is VERY important to consider that altering tables can
require a bit of time for very large tables, and that while the
table is locked, other users and processes cannot operate.
Consequently, this kind of modification should not be done
during peak operating hours in a production operation (as a
student in a lab exercise, working on your own database, you
may do this at any time) but ideally in hours during which
the business does not normally operate. In cases where
round-the-clock, high availability of a database is required,
other approaches may be required. Addressing this problem
in a high-availability, high-demand environment is an
advanced topic, study of which is outside the scope of this
course. Use the outline below to construct your script. Show
all commands in your answer sheet along with the output of
the commands.
lock table customers write;
set foreign_key_checks = 0;
– Replace this comment with your ALTER TABLE
command to add the auto_increment feature to the PK field
set foreign_key_checks = 1;
unlock tables;
–statements to insert two rows into the table
–verify auto_increment with a select statement