Question

mysql 存储过程,第一个变量就报错,为什么.

DELIMITER //
CREATE PROCEDURE hual

DECLARE @hualxa varchar(20)
DECLARE @hualxb varchar(20)
DECLARE @hualxc varchar(20)
DECLARE @huald varchar(20)
DECLARE @huale varchar(20)
DECLARE @hualf varchar(20)

begin
select @huald=(select maca from radcheck where username=@hualxb)
select @huale=(select macb from radcheck where username=@hualxb)
select @hualf=(select macc from radcheck where username=@hualxb)

if((@hualxc == 'Access-Reject') and (@huald='a') ) then
update radcheck set maca=@hualxa where username=@hualxb and maca='a';
else
if((@hualxc == 'Access-Reject') and (@huale='a') ) then
update radcheck set macb=@hualxa where username=@hualxb and macb='a';
else
if((@hualxc == 'Access-Reject') and (@hualf='a') ) then
update radcheck set macc=@hualxa where username=@hualxb and macc='a';
else
end;
end
//
DELIMITER;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@hualxa varchar

@hualxb varchar
@hualxc varchar
as

begin
declare @huald varcha' at line 3
mysql>
mysql> DELIMITER;

*******************************************************************

• 你的回答被采纳后将获得：
• 系统奖励15（财富值+成长值）+难题奖励30（财富值+成长值）

Answer 1

每句话后面加上分号，可以不？你一直不结束，它能不报错吗

Answer 2

这是真的吗。