无详细内容 mysql mysqlmysql delimiter //mysql create function myproc (cost decimal(10,2)) - returns decimal(10,2) - - sql security definer - - tax: begin - declare order_tax decimal(10,2); - set order_tax = cost * .05; - return order_tax; -
mysql mysql>mysql> delimiter //mysql> create function myproc (cost decimal(10,2)) -> returns decimal(10,2) -> -> sql security definer -> -> tax: begin -> declare order_tax decimal(10,2); -> set order_tax = cost * .05; -> return order_tax; -> end -> //query ok, 0 rows affected (0.00 sec)mysql> delimiter ;mysql>mysql> select myproc(123.45);+----------------+| myproc(123.45) |+----------------+| 6.17 |+----------------+1 row in set, 1 warning (0.00 sec)mysql>mysql> drop function myproc;query ok, 0 rows affected (0.00 sec)mysql>