Answered step by step
Verified Expert Solution
Question
1 Approved Answer
myguitarshop mysql 6. (10) Write a stored procedure named spinsertCategory. The procedure has one parameter variable (accepts one argument), which is the name of the
myguitarshop
mysql
6. (10) Write a stored procedure named spinsertCategory. The procedure has one parameter variable (accepts one argument), which is the name of the new category that you want to insert in the Categories table and returns nothing. If the insert is successful, the procedure should print that the insert was successful. If the insert was not successful, the procedure should print that the insert failed. (5) Code one EXEC statement that calls/tests this procedure with a valid category name. (5) Code another EXEC statement that calls/tests this procedure with an invalid category name. Note that this table doesn't allow duplicate category names. 6. (10) Write a stored procedure named spinsertCategory. The procedure has one parameter variable (accepts one argument), which is the name of the new category that you want to insert in the Categories table and returns nothing. If the insert is successful, the procedure should print that the insert was successful. If the insert was not successful, the procedure should print that the insert failed. (5) Code one EXEC statement that calls/tests this procedure with a valid category name. (5) Code another EXEC statement that calls/tests this procedure with an invalid category name. Note that this table doesn't allow duplicate category names Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started