mysql触发器的问题 Not allowed to return a result set from a trigger

Question

本帖最后由 skyshit 于 2011-12-28 00:46:00 编辑

Answer 1

问题在“SELECT TMP_newBalance=balance from cb_USER where telephone=new.telephone;”
trigger 中不允许返回select出来的结果集

Answer 2

MYSQL中语法应该如下 。SELECT balance into TMP_newBalance from cb_USER where telephone=new.telephone;

Answer 3

MYSQL中语法应该如下 。SELECT balance into TMP_newBalance from cb_USER where telephone=new.telephone;

Answer 4

SELECT TMP_newBalance=balance from cb_USER where telephone=new.telephone;->
SELECT balance INTO TMP_newBalance from cb_USER where telephone=new.telephone;

Answer 5

SELECT TMP_newBalance=balance from cb_USER where telephone=new.telephone;->
SELECT balance INTO TMP_newBalance from cb_USER where telephone=new.telephone;