Demo entry 6745331

test

   

Submitted by anonymous on May 26, 2018 at 15:32
Language: SQL. Code size: 425 Bytes.

mysql> delimiter //
mysql> create procedure gradeavg() begin select Avg(grade) AS gradeaverage from grade;end//
Query OK, 0 rows affected (0.10 sec)

mysql> delimiter ;
mysql> call gradeavg();
+--------------+
| gradeaverage |
+--------------+
|      77.2500 |
+--------------+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> drop procedure gradeavg;
Query OK, 0 rows affected (0.03 sec)

This snippet took 0.00 seconds to highlight.

Back to the Entry List or Home.

Delete this entry (admin only).