各位大侠 本人刚接触 mysql 为啥报这样的错误啊 CREATE DEFINER=`root`@`%` FUNCTION `doRecruiterEduFilter`(`i_postReqId` VARCHAR(20)) RETURNS VARCHAR(100) CHARSET gbk
BEGIN
-- 1.根据招聘岗位要求ID,查询出年龄起止值
DECLARE v_ageBeg INT;
DECLARE v_ageEnd INT;
SELECT v_ageBeg = ageBeg FROM CSV_Empl_PostRequest WHERE postReqId=i_postReqId;
SELECT v_ageEnd = ageEnd FROM CSV_Empl_PostRequest WHERE postReqId=i_postReqId;
CREATE TABLE temp(appJobId VARCHAR(50));
IF(v_ageBeg =-1)THEN
BEGIN
SET v_ageBeg = 0;
END;
END IF;
IF(v_ageEnd =-1)THEN
BEGIN
SET v_ageEnd =120;
END;
END IF;
-- 做本地求职年龄筛选
SELECT a.appJobId INTO temp FROM CSV_Empl_InAppJobs a WHERE age >=v_ageBeg AND age <=v_ageEnd;
RETURN '';
END;Error Code : 1327
Undeclared variable: temp
BEGIN
-- 1.根据招聘岗位要求ID,查询出年龄起止值
DECLARE v_ageBeg INT;
DECLARE v_ageEnd INT;
SELECT v_ageBeg = ageBeg FROM CSV_Empl_PostRequest WHERE postReqId=i_postReqId;
SELECT v_ageEnd = ageEnd FROM CSV_Empl_PostRequest WHERE postReqId=i_postReqId;
CREATE TABLE temp(appJobId VARCHAR(50));
IF(v_ageBeg =-1)THEN
BEGIN
SET v_ageBeg = 0;
END;
END IF;
IF(v_ageEnd =-1)THEN
BEGIN
SET v_ageEnd =120;
END;
END IF;
-- 做本地求职年龄筛选
SELECT a.appJobId INTO temp FROM CSV_Empl_InAppJobs a WHERE age >=v_ageBeg AND age <=v_ageEnd;
RETURN '';
END;Error Code : 1327
Undeclared variable: temp
解决方案 »
- Exception in thread "main" java.sql.SQLException 帮忙解决下!!
- 请教一个关于去除数据的语句
- 一个mysql的存储过程,哪里有问题?
- mysql中的表类型从innodb改成myisam类型出现the total number of locks exceeds the lock table si
- 请教一个简单问题,散分了!!。。。。。。。。
- 日期?
- MySQl下,建的外键引用不起作用,为啥
- 一个非常简单的问题,急
- 如何才能把mysql的数据导入oracle 9i上?
- 我在一台有静态地址的机器上(Linux)安装了MySql,在其它机器上用PHP或C怎样远程访问MySql?
- MySQL 监视器的问题
- MYSQL如何连接字符,并 exec sp_executesql 拼接的字符串
要生成TEMP表?
如是,你已经建立了此表
insert into temp
SELECT a.appJobId FROM CSV_Empl_InAppJobs a WHERE age >=v_ageBeg AND age <=v_ageEnd;
BEGIN
-- 1.根据招聘岗位要求ID,查询出年龄起止值
DECLARE v_ageBeg INT;
DECLARE v_ageEnd INT;
SELECT v_ageBeg = ageBeg FROM CSV_Empl_PostRequest WHERE postReqId=i_postReqId;
SELECT v_ageEnd = ageEnd FROM CSV_Empl_PostRequest WHERE postReqId=i_postReqId;
CREATE TABLE temp(appJobId VARCHAR(50));
IF(v_ageBeg =-1)THEN
BEGIN
SET v_ageBeg = 0;
END;
END IF;
IF(v_ageEnd =-1)THEN
BEGIN
SET v_ageEnd =120;
END;
END IF;
-- 做本地求职年龄筛选
insert into temp select a.appJobId FROM CSV_Empl_InAppJobs a WHERE age >=v_ageBeg AND age <=v_ageEnd;
-- SELECT a.appJobId INTO temp FROM CSV_Empl_InAppJobs a WHERE age >=v_ageBeg AND age <=v_ageEnd;
RETURN '';
END;