Class 13

Based on the 28/5/19 dat602 class.

Functions can’t return values for a set. For our project we will need to find a way of working around this and tricking the program into be leaving that the the function is returning a single function.

Procedure can pretty much do anything so we don’t have to worry about this with them.

Procedure let us re use code and automate things. This will be useful in our project by allowing us to reuse parts of the program such as change a user statics or updating a pieces persecution.

Transitional squeal allows as to make a change to a database with out committing it, so we don’t have to worry about breaking the database. We must use commit to commit it and we can use rollback to go back to the prior state.

The default perameter in mySQL is IN so we must tell it that we want stuff to be passed out.