MySQL Forums
Forum List  »  Spanish

Re: Como ejecutar comandos dinamico sql en triggers
Posted by: William Chiquito
Date: May 16, 2007 10:27AM

Hola Norman,

Lo que deseas hacer actualmente está complicado ya que MySQL no soporta sentencias preparadas (prepared statements) en funciones almacenadas o triggers.

Quote

13.7. SQL Syntax for Prepared Statements
SQL syntax for prepared statements cannot be used within stored routines (procedures or functions), or triggers. This restriction is lifted as of MySQL 5.0.13 for stored procedures, but not for stored functions or triggers.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Como ejecutar comandos dinamico sql en triggers
4155
May 16, 2007 10:27AM


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.