Question

6. Create a reusable stored procedure named “add_like" that uses parameters and allows you to insert any new "like". Rather than passing in the person_id value as parameters to identify

which person is liking which post, pass in the username of the person.The stored procedure should then lookup the person_id and store it in a variable to be used in the insert statement. Execute the procedure to add a "like" of your choosing, then list out the Like table to show the addition succeeded.

Fig: 1