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
Last activity: Aug 14, 2020, 01:57 PM