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

Table_Name; For example, to select all columns from the Student
table, the command would be
SELECT * FROM student;
Be sure to save all of the above statements in your script file.
STEP 5: Testing and Verifying Your Script
Now we come to the point of verifying that your script file works by
creating all of the tables and
inserting and selecting all of the data. Your script should execute
without errors, and select the entire
contents of each table in turn. Inspect your query results to ensure that
each column and row from
each of the tables is as expected. Correct and repeat testing of your
script until no errors occur, and the
results match expectations. You may also use the DESCRIBE
command to display the table structure of
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;