问题在“SELECT TMP_newBalance=balance from cb_USER where telephone=new.telephone;” trigger 中不允许返回select出来的结果集
MYSQL中语法应该如下 。SELECT balance into TMP_newBalance from cb_USER where telephone=new.telephone;
MYSQL中语法应该如下 。SELECT balance into TMP_newBalance from cb_USER where telephone=new.telephone;
SELECT TMP_newBalance=balance from cb_USER where telephone=new.telephone;-> SELECT balance INTO TMP_newBalance from cb_USER where telephone=new.telephone;
SELECT TMP_newBalance=balance from cb_USER where telephone=new.telephone;-> SELECT balance INTO TMP_newBalance from cb_USER where telephone=new.telephone;
trigger 中不允许返回select出来的结果集
SELECT balance INTO TMP_newBalance from cb_USER where telephone=new.telephone;
SELECT balance INTO TMP_newBalance from cb_USER where telephone=new.telephone;