mysql存储过程与函数 - 数据库编程

turn 返回类型
begin
函数体;
end

mysql> create function dd(ss char(20)) 
    -> returns date 
    -> begin  
    -> return (date(ss)); 
    -> end//
mysql> select dd('2012-12-12 12:12:12')//
+---------------------------+
| dd('2012-12-12 12:12:12') |
+---------------------------+
| 2012-12-12                |
+---------------------------+
1 row in set (0.00 sec)

mysql> select * from student//
+------+---------+------+-------+
| name | address | sid  | score |
+------+---------+------+-------+
| zh   | beijing |    1 |    70 |
+------+---------+------+-------+
1 row in set (0.00 sec)

mysql> create function dd(id int) 
    -> returns int 
    -> begin  return (select score from student where id=id); 
    -> end//
Query OK, 0 rows affected (0.00 sec)

mysql> select dd(1)//
+-------+
| dd(1) |
+-------+
|    70 |
+-------+
1 row in set (0.00 sec)

mysql存储过程与函数(二)