DECLARE m_UserID int;
SELECT UserID INTO m_UserID FROM t_user WHERE UserName='A'; IF m_UserID IS NULL THEN
INSERT INTO t_user(UserID,UserName,UserPwd)
VALUES (NULL,'A','1234'); SELECT LAST_INSERT_ID() AS UserID;
END IF; IF m_UserID IS NOT NULL THEN
SELECT m_UserID AS UserID;
END IF;
SELECT UserID INTO m_UserID FROM t_user WHERE UserName='A'; IF m_UserID IS NULL THEN
INSERT INTO t_user(UserID,UserName,UserPwd)
VALUES (NULL,'A','1234'); SELECT LAST_INSERT_ID() AS UserID;
END IF; IF m_UserID IS NOT NULL THEN
SELECT m_UserID AS UserID;
END IF;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货