MySQL 存储过程的 BEGIN 和 END

Question

1. mysql>
2. mysql> DELIMITER //
3. mysql> CREATE FUNCTION myProc (cost DECIMAL(10,2))
4.     -> RETURNS DECIMAL(10,2)
5.     ->
6.     -> SQL SECURITY DEFINER
7.     ->
8.     -> tax: BEGIN
9.     ->     DECLARE order_tax DECIMAL(10,2);
10.     ->     SET order_tax = cost * .05;
11.     ->     RETURN order_tax;
12.     -> END
13.     -> //
14. Query OK, 0 rows affected (0.00 sec)
16. mysql> DELIMITER ;
17. mysql>
18. mysql> select myProc(123.45);
19. +----------------+
20. | myProc(123.45) |
21. +----------------+
22. |           6.17 |
23. +----------------+
24. 1 row in set, 1 warning (0.00 sec)
26. mysql>
27. mysql> drop function myProc;
28. Query OK, 0 rows affected (0.00 sec)
30. mysql>

复制代码