求助一下set @openid1 =(select openid from table1 where tel='13812345678');
select @openid1;IF (@openid1 is null) OR (@openid1='') THEN
set @openid1 =(select openid from table2 where tel='13812345678');
END IF
select @openid1;
上面的代码会提示错误在
IF (@openid1 is null) OR (@openid1='') THEN
set @openid1 =(select openid from table2 where tel='13812345678');
END IF
select @openid1;
这一段中,改了好久没改对
select @openid1;IF (@openid1 is null) OR (@openid1='') THEN
set @openid1 =(select openid from table2 where tel='13812345678');
END IF
select @openid1;
上面的代码会提示错误在
IF (@openid1 is null) OR (@openid1='') THEN
set @openid1 =(select openid from table2 where tel='13812345678');
END IF
select @openid1;
这一段中,改了好久没改对
SET @openid1 =(select openid from table1 where tel='13812345678');
SELECT @openid1;IF (@openid1 is null) OR (@openid1='') THEN
set @openid1 =(select openid from table2 where tel='13812345678');
END IF;
select @openid1;
END IF 这里要以分号结尾