28/03/2012, 03:39
|
| | | Fecha de Ingreso: junio-2011
Mensajes: 139
Antigüedad: 12 años, 10 meses Puntos: 42 | |
| Respuesta: Hacer select en trigger
Hola Yoi,
Textualmente del manual de MySQL: Cita: E.1. Restrictions on Stored Programs
...
The restrictions for stored functions also apply to triggers.
... Restrictions for Stored Functions
... - Statements that return a result set. This includes SELECT statements that do not have an INTO var_list clause and other statements such as SHOW, EXPLAIN, and CHECK TABLE. A function can process a result set either with SELECT ... INTO var_list or by using a cursor and FETCH statements.
|