这是我的存储过程: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 这个语法有问题吗?
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 这个语法有问题吗?
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 ;