Re: ejecutar cadenas dentro de un stored procedure
el equivalente en mysql de la instruccion exec 'update tablapepito set numero=1'
seria la siguiente.
SET @query = ''update tablapepito set numero=1' ;
PREPARE strsql FROM @query;
EXECUTE strsql;
y con respecto a la segunda pregunta creo que es porque las tablas myisam no permiten multiples querys las tendrias que poner en innodb
Subject
Views
Written By
Posted
6855
April 15, 2010 12:42PM
2155
April 19, 2010 07:24AM
Re: ejecutar cadenas dentro de un stored procedure
2646
June 30, 2010 04:50AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.