There are 5 SQL files for the Person table:
These files should be executed in order except that person-select.sql is also executed after person-update.sql and person-delete.sql to view the effects.
You can execute an SQL file by right-clicking on the file and selecting "Run File" from the popup menu. The left screenshot below shows the menus for the person-create.sql file.
This will bring up a "Select Database Connection" dialog as shown in the right screenshot. Be sure to select the correct connection.
You can view the expected results by clicking on the "After Create" menu item in this presentation.
This is the expected result after executing person-create.sql.
You may have also noticed another file briefly displayed before the results appeared. That was the person-create.sql file. You can view it by clicking on the "person-create.sql" tab.
Repeat the steps for executing person-create.sql except start by right-clicking on person-insert.sql.
Repeat the steps for executing person-create.sql except start by right-clicking on person-select.sql.
Click on the "person-select.sql" tab to see the SQL file and its execution results. The expected results are shown below.
Repeat the steps for executing person-create.sql except start by right-clicking on person-update.sql.
To view the changes click on the "person-select.sql" tab then click on
the execute button (
).
After the the execution completes click on the "person-select.sql" tab
again.
The expected results are shown below.
Note that Jane Doe's first name has changed from Jane to Janet.
Repeat the steps for executing person-create.sql except start by right-clicking on person-delete.sql.
To view the changes click on the "person-select.sql" tab then click on
the execute button ().
After the the execution completes click on the "person-select.sql" tab
again.
The expected results are shown below.
Note that the row for Jim Smith has been deleted.
