56,677
社区成员
发帖
与我相关
我的任务
分享
mysql> CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50)
-> RETURN CONCAT('Hello, ',s,'!');
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT hello('world');
+----------------+
| hello('world') |
+----------------+
| Hello, world! |
+----------------+
1 row in set (0.00 sec)
mysql> delimiter //
mysql> CREATE FUNCTION get_ai_id_by_key(key_id_var INT, domain_id_var INT)
-> RETURNS CURSOR
-> BEGIN
-> DECLARE curs CURSOR FOR SELECT key_id FROM prc_ai_define WHERE (to_number(substr(key_id, 1, 10)) = key_id_var) and (domain_id=domain_id_var);
-> RETURN curs;
-> END;
-> //
Query OK, 0 rows affected (0.00 sec)
mysql> delimiter ;