This week I learned about creating SQL procedures and how to change the delimiter (;). The delimiter sometimes needs to be temporarily changed so that procedures can be made, because otherwise the normal delimiter (;) would incorrectly mark the end of the procedure. After the procedure the delimiter is then changed back to the default.
After it’s created a procedure can be called, thereby running the contained SQL script.
This will help me creating the necessary scripting required as part of the course and will aid in my ability to create functional scripts in the future.
The other thing we covered was flow control which, in this context, is about the actions and decisions that are made by a program either by itself or due to user input.
This will allow me to properly plan out the operations that will be a part of my game.