This is a repo for the solutions of the computer science practicals. 🙂
- Please check if everything works because I didn't write any tests
- If there are any problems, make changes, write commit message, and make a PR.
- Make sure to follow the naming convention
Note: If the code works, please leave it alone.
- open the mysql prompt in this directory.
source table-creation.sql;
source data_initialisation.sql
Notes:
-
You would only need to run the table creation script once, unless you changed the structure and want to reset it. In such a case, make sure to drop the existing table before running the script.
-
data_initialisation.sql removes all data from the records before inserting. Highly recommend using transactions to deal with it.