创建存储过程出错 Undeclared variable:t
这是我的存储过程:
-
SQL code
drop procedure if exists select_app; delimiter // create procedure select_app(in timei varchar(50),out tappid varchar(10),out tappsecret varchar(50)) begin DECLARE start varchar(50) ; DECLARE iend varchar(50); DECLARE ttype int; select t.startimei into start ,t.endimei into iend, t.type into ttype from t_imei_typeinfo as t , t_imei_entityinfo as e where e.imei = timei and e.type = t.type; if (timei > start && timei < tend) select appid,appsecret from t_disktypeinfo where type = ttype; end if; end// delimiter ;
创建的时候报Undeclared variable:t 这个语法有问题吗?
select t.startimei ,t.endimei, t.type into startinto , , ttype from t_imei_typeinfo as t , t_imei_entityinfo as e where e.imei = timei and e.type = t.type;
DROP PROCEDURE IF EXISTS select_app;
DELIMITER //
CREATE PROCEDURE select_app(IN timei VARCHAR(50),OUT tappid VARCHAR(10),OUT tappsecret VARCHAR(50))
BEGIN
DECLARE `start` VARCHAR(50) ;
DECLARE iend VARCHAR(50);
DECLARE ttype INT;
SELECT startimei ,endimei , `TYPE` INTO `start` ,iend , ttype FROM t_imei_typeinfo AS t , t_imei_entityinfo AS e WHERE e.imei = timei AND e.type = t.type;
IF (timei > `start` AND timei < tend) THEN
SELECT appid,appsecret FROM t_disktypeinfo WHERE `type` = ttype;
END IF;
END//
DELIMITER ;