各位大侠 本人刚接触 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
解决方案 »
- mysql安装后如何设置密码,登录后找不到mysql库
- 关于sql语句中数值转换的问题
- MySql Query Browser事务未提交,隔离级别read committed也能脏读?
- 请问一个SELECT FOR UPDATE的问题
- mysql连表查询
- 中文全文检索
- Can not issue data manipulation statements with executeQuery()什么意思呢?
- Mysql 怎么 在 触发器 中 抛出异常和取消操作 ???
- 关于mysql的用户及权限问题
- MYSQL UPDATE的奇怪问题
- 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;