if exists(select 1 from ucenter.uc_members where username='yewuyuan')
begin
select uid from ucenter.uc_members where username='yewuyuan';
end
else
begin insert ucenter.uc_members (username,password,regdate,email,salt) values ('yewuyuan','ce88becac5e68884fff601a96047d5c2',UNIX_TIMESTAMP('2007-1-11 11:14:00'),'','123456'); set @uid=LAST_INSERT_ID(); insert cdb_members (uid,username,password,regdate,lastvisit,lastactivity,email,groupid ,pmsound,newsletter,timeoffset,credits,sigstatus) values (@uid,'yewuyuan','ce88becac5e68884fff601a96047d5c2',UNIX_TIMESTAMP('2007-1-11 11:14:00'),UNIX_TIMESTAMP('2007-1-11 11:14:00'),UNIX_TIMESTAMP('2007-1-11 11:14:00'),'','10','1','1','9999','0','1'); select @uid; end
begin
select uid from ucenter.uc_members where username='yewuyuan';
end
else
begin insert ucenter.uc_members (username,password,regdate,email,salt) values ('yewuyuan','ce88becac5e68884fff601a96047d5c2',UNIX_TIMESTAMP('2007-1-11 11:14:00'),'','123456'); set @uid=LAST_INSERT_ID(); insert cdb_members (uid,username,password,regdate,lastvisit,lastactivity,email,groupid ,pmsound,newsletter,timeoffset,credits,sigstatus) values (@uid,'yewuyuan','ce88becac5e68884fff601a96047d5c2',UNIX_TIMESTAMP('2007-1-11 11:14:00'),UNIX_TIMESTAMP('2007-1-11 11:14:00'),UNIX_TIMESTAMP('2007-1-11 11:14:00'),'','10','1','1','9999','0','1'); select @uid; end
if @ee>=1 then
.....
if @cnt>=1 then
select uid from ucenter.uc_members where username='yewuyuan';
else
insert ucenter.uc_members (username,password,regdate,email,salt) values ('yewuyuan','ce88becac5e68884fff601a96047d5c2',UNIX_TIMESTAMP('2007-1-11 11:14:00'),'','123456');
set @uid=LAST_INSERT_ID();
insert cdb_members (uid,username,password,regdate,lastvisit,lastactivity,email,groupid ,pmsound,newsletter,timeoffset,credits,sigstatus) values (@uid,'yewuyuan','ce88becac5e68884fff601a96047d5c2',UNIX_TIMESTAMP('2007-1-11 11:14:00'),UNIX_TIMESTAMP('2007-1-11 11:14:00'),UNIX_TIMESTAMP('2007-1-11 11:14:00'),'','10','1','1','9999','0','1');
select @uid;
end if
if else是不是只能用在mysql的存储过程里呀,
if else是不是只能用在mysql的存储过程里呀,
mySQL毕竟不是MS SQL,不支持这种语句块的用法。你可以参考一下相关的mySQL官方文档
http://dev.mysql.com/doc/refman/5.1/zh/index.html