III Stored Procedures

15. You will need to create a new table to test your stored procedure on. Include the CREATE statement for that table in your Word document. (You will need appropriate insert statements as well.)

16. Create a stored procedure of your choice. Show me your code. a. When testing it, remember to change the delimiter on phpmyadmin or you will get an error. b. Your stored procedure must be different than the example in the video (not just increasing or decreasing).

17. Write the sql command to call your procedure.

18. Verify it worked show me your before and after output (A screenshot before calling the stored procedure, code for calling the procedure, and a screenshot after so I can see it working.)