Note These scripts are for you to test that your setup works correctly. The lab assignment asks you to name files in a specific way, and to place them in specific directories. All scripts should be run from the root of your Lab 2 directory. You can either run them from command line:
$mysql < build-all.sql
or from inside the mysql client
MySQL[dekhtyar]> source build-all.sql
The three scipts below are single use scripts.
|creates and populates all tables in all databases
|(it only succeeds if all your table names are unique)
|runs all your test scriptsd
|drops all tables
|simply chains the three scripts above together
Note: You can also create a redo.sql script by placing the source clean-all.sql at the top of the script.
We have one more script.
|runs setup, insertion, test, and cleanup one database at a time