Fill This Form To Receive Instant Help
Homework answers / question archive / Experiment 5: Trigger, Procedure and Function Goal To practice how to create the trigger/procedure/function
To practice how to create the trigger/procedure/function.
For example: input: J2, output: ‘JINGYI, SHENGXIN, WEIMIN'. (10 points)
Hint: use the command ‘show create procedure jsearch1’. For convenience of viewing, you can add \G at the end of the above command and display it in the form of two columns of text.
Hint: Show procedure status like 'jsearch%';
Hint: in mysql, you need to create three triggers for insert, update and delete actions. You can first design and implement a common procedure, and then call the stored procedure in the 3 triggers.