刚学数据库我想通过if语句控制事务,自认为没写错但是一直报错,不知道具体是哪儿错了,求告知!
START TRANSACTION;
SET @money = 1000;
SET @m_money =(SELECT money FROM mom);
IF @m_money>=1000 THEN
UPDATE mom SET money=money-1000 WHERE m_name=1;
UPDATE son SET money=money+1000 WHERE s_name=1;
COMMIT;
ELSE THEN
ROLLBACK;
END IF;