CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c | Page 56

each table, and verify that PK and NULL constraints have been
properly created. The SHOW CREATE
TABLE statement is useful for displaying the SQL that would
regenerate a given table, which is a useful
way for checking that FKs have been properly created.
Examples:
DESCRIBE STUDENT;
SHOW CREATE TABLE STUDENT;
This is the end of Lab 3_____
===========================================
CIS 336 iLab 4 Introduction to Select, Insert, Update, and
Delete Statements (only SQL Command, No output)
FOR MORE CLASSES VISIT
www.cis336study.com
CIS336: Lab 4: Introduction to Select, Insert, Update, and Delete
Statements
LAB OVERVIEW
Lab 4 will introduce the various aspects of the SQL select statement
and the methods of retrieving data from the database tables. This
lab will also introduce the fundamentals of updating and deleting
records. This lab may be completed using either DeVry‘sOmnymbus
EDUPE-APP lab environment, or a local copy of the MySQL
database running on your own computer using the OM database