我们最常见的报错信息
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 'return returnTime;
end' at line 13
单引号括起来的部分就是报错的位置,但实际错误的语句就是单引号括起来的前面一句的语句错误
下面是我写的自定义函数
##随机时间age
drop FUNCTION if exists getTime;
delimiter $$
create function getTime()
returns TIMESTAMP
no sql
begin
declare randNum int(2) default 0;
declare returnTime TIMESTAMP;
set randNum=floor(rand()*10);
IF randNum<5 THEN
set returnTime=date_add(curdate(),interval floor(1-(rand()*365))day);
ELSE
set returnTime=date_add(curdate(),interval floor(1+(rand()*365))day);
END IF
return returnTime;
end $$
报错显示最后一句'return returnTime; end',错误处:前一句END IF (未加分号结尾)
正确语法
##随机时间age
drop FUNCTION if exists getTime;
delimiter $$
create function getTime()
returns TIMESTAMP
no sql
begin
declare randNum int(2) default 0;
declare returnTime TIMESTAMP;
set randNum=floor(rand()*10);
IF randNum<5 THEN
set returnTime=date_add(curdate(),interval floor(1-(rand()*365))day);
ELSE
set returnTime=date_add(curdate(),interval floor(1+(rand()*365))day);
END IF;
return returnTime;
end $$
还有要注意的是,赋值的时候一定要加set,本人正是因为这个问题一直没发现,才在此深刻检讨