MySQL Error--1415 not allowed to return a result set from a trigger

A query in the form of a select * from table cannot appear in MySQL's Trigger and function because it returns a result set, which is unacceptable in MySQL's trigger and function, but can be used in stored procedures. In Trigger and function you can use SELECT ... into ... form of the query.

New is the value.
Old is a previous value

INSERT only New
Update has new and old
Delete is only old

Http://www.2cto.com/database/201301/186392.html

MySQL Error--1415 not allowed to return a result set from a trigger