mysql 创建function

mysql> use school;
Database changed
mysql> delimiter

$$mysql> create function fun() -> returns int -> begin -> select count(*) into @result from course; -> return @result; -> end ->$$
Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;
mysql>
mysql> select fun();
+——-+
| fun() |
+——-+
| 2 |
+——-+
1 row in set (0.00 sec)

mysql>

截图：