Sample Header Ad - 728x90

MYSQL Stored procedure to fetch entire row from a table

1 vote
1 answer
1613 views
I am a beginner to SQL and currently practicing the concept of the stored procedure. I have a table Fetch_Marks that contains 20 records with Student_No and Marks as columns. Now I would like to create a stored procedure for this in which the input parameter will be Student_No and when we enter the input (Let's say I gave the Student_No as 1), it should fetch the row of that particular student from the table Fetch_Marks. Is there any workaround for this? If yes, please help.
Asked by Novice Developer (15 rep)
Aug 14, 2020, 09:44 AM
Last activity: Aug 14, 2020, 01:57 PM