Dear Viewers,
This post demonstrates MySql stored procedure and stored function. Small dataset considered is as below
mysql> select * from student;
+------+---------+-------+----------+
| rno | name | class | division |
+------+---------+-------+----------+
| 1 | John | TE | A |
| 2 | Peter | TE | A |
| 1 | David | TE | B |
| 2 | Solomon | TE | B |
+------+---------+-------+----------+
This post demonstrates MySql stored procedure and stored function. Small dataset considered is as below
mysql> select * from student;
+------+---------+-------+----------+
| rno | name | class | division |
+------+---------+-------+----------+
| 1 | John | TE | A |
| 2 | Peter | TE | A |
| 1 | David | TE | B |
| 2 | Solomon | TE | B |
+------+---------+-------+----------+