Given the database table below, write a stored procedure called SP GetBCStationI

Question

Given the database table below, write a stored procedure called SP GetBCStationInfo This stored procedure will accept a single argument that represents the format field. The stored procedure will get all information from the table below based on this parameter and order the data by 'city'. You will create this stored procedure in a text file that can be run using the MySQL 'source' command. Write the Stored Procedure below: Show an example how this stored procedure would be called using the MySQL command line interface:

Explanation / Answer

Procedure to get station info:

CREATE PROCEDURE SP_GetBCstationinfo ( IN format_ip varchar(25))

BEGIN

SELECT * FROM fn_stations WHERE format = format_ip order by city;

END //

Simply call the above procedure along with input format so that you will get the correct output.

call SP_GetBCstationinfo(7);

It will retrieve all the data related to format 7

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.