Ver Mensaje Individual
  #2 (permalink)  
Antiguo 28/03/2012, 04:39
wchiquito
 
Fecha de Ingreso: junio-2011
Mensajes: 139
Antigüedad: 8 años, 7 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.