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)