mysql日常工作手记(持续更新)
查看函数是否开启：mysql> show variables like '%func%';
+---------------------------------+-------+
| Variable_name | Value |
+---------------------------------+-------+
| log_bin_trust_function_creators | ON |
+---------------------------------+-------+
1 row in set (0.00 sec)
启用函数：
mysql> set global log_bin_trust_function_creators=1;
创建函数：
mysql> use web_platform
Database changed
mysql> DELIMITER $$
mysql> CREATE DEFINER=`web_platform_pro`@`10.10.0.%` FUNCTION `currval`(`s_seq_name` VARCHAR(20)) RETURNS int(11)
-> BEGIN
-> DECLARE n_value INTEGER;
-> SET n_value = 0;
-> SELECT current_value INTO n_value
-> FROM t_sequence
-> WHERE name = s_seq_name;
-> RETURN n_value;
-> END
-> $$
Query OK, 0 rows affected, 1 warning (0.00 sec)
PS:$$是设置 $$为命令终止符号，代替分号，因为分号在begin...end中会用到；
查看函数：
mysql> show function status\G
*************************** 1. row ***************************
Db: web_platform
Name: currval
Type: FUNCTION
Definer: web_platform_pro@10.10.0.%
Modified: 2013-11-01 20:35:42
Created: 2013-11-01 20:35:42
Security_type: DEFINER
Comment:
character_set_client: latin1
collation_connection: latin1_swedish_ci
Database Collation: utf8_general_ci
删除函数：
mysql> drop function currval;
Query OK, 0 rows affected (0.00 sec)
页:
[1]