请问我这段程序哪错了。。
start transaction ;
set @newversion='0.0.3.0';
set @version1='0.0.1.0';
set @version2='0.0.2.0';
set @noupdata='不需要更新';
set @temp ='';
set @temp:=(select version from ver where id=1);
if select (@newversion<=>@temp ) when select noupdata;
else
if select (@temp <=> @version1) when update data set name='aaaa' where id = 3 ;
else
if (select @temp <=> @version2) when ALTER TABLE data ADD age varchar(10) ;
end if;
end if;
end if; commit;
start transaction ;
set @newversion='0.0.3.0';
set @version1='0.0.1.0';
set @version2='0.0.2.0';
set @noupdata='不需要更新';
set @temp ='';
set @temp:=(select version from ver where id=1);
if select (@newversion<=>@temp ) when select noupdata;
else
if select (@temp <=> @version1) when update data set name='aaaa' where id = 3 ;
else
if (select @temp <=> @version2) when ALTER TABLE data ADD age varchar(10) ;
end if;
end if;
end if; commit;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货