CREATE FUNCTION `zrcrmdb`.`format_phone`(old_phone varchar(15))
RETURNS varchar(15)
BEGIN
DECLARE new_phone varchar(15)
IF LENGTH(old_phone)=8 THEN
SET new_phone=concat('025',old_phone)
ELSE
SET new_phone=old_phone
END IF
RETURN new_phone
END错误如下:Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF LENGTH(old_phone)=8 THEN
SET new_phone=concat('025',old_phone)
ELSE
SET ' at line 5Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000请求帮助解决
RETURNS varchar(15)
BEGIN
DECLARE new_phone varchar(15)
IF LENGTH(old_phone)=8 THEN
SET new_phone=concat('025',old_phone)
ELSE
SET new_phone=old_phone
END IF
RETURN new_phone
END错误如下:Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF LENGTH(old_phone)=8 THEN
SET new_phone=concat('025',old_phone)
ELSE
SET ' at line 5Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000请求帮助解决
解决方案 »
- mysql右表如何引用左表的值?
- mysql所有的数据库后缀为*.MYD大小都为0,怎么回事?
- 如何将MYSQL字段设置成默认当前时间戳?
- MySQL安全问题
- 请问:table1表中的number记录了table2中的记录数,当table2加删记录时, 怎样用SQL语句更新这个number
- 我该如何生成一个MYSQL数据库ac?
- postgreSQL的问题(linux). 急!!
- mysql怎么不能启动?
- mysql存储过程一个参数有多个逗号分割
- 【求助】mysql workbench看不到自己建立的触发器,其他表的可以看到
- mysql可以实现一个数据库,只体现为一个文件吗?就象ms sqlserver那样?
- mysql可以实现,同一个数据库中,不同的表应用不存的存贮引擎吗?
CREATE FUNCTION `zrcrmdb`.`format_phone`(old_phone VARCHAR(15)) RETURNS VARCHAR(15)
BEGIN
DECLARE new_phone VARCHAR(15);
IF LENGTH(old_phone)=8 THEN
SET new_phone=CONCAT('025',old_phone);
ELSE
SET new_phone=old_phone ;
END IF ;
RETURN new_phone ;
END$$
SELECT IF(LENGTH(old_phone)=8,CONCAT('025',old_phone),old_phone) FROM
CREATE FUNCTION `format_phone`(old_phone VARCHAR(15)) RETURNS VARCHAR(15)
NO SQL
DETERMINISTIC
BEGIN
DECLARE new_phone VARCHAR(15);
IF LENGTH(old_phone)=8 THEN
SET new_phone=CONCAT('025',old_phone);
ELSE
SET new_phone=old_phone ;
END IF ;
RETURN new_phone ;
END $$