Ezhilarasan Sammandam <[EMAIL PROTECTED]> wrote on 12/30/2005 08:53:36 AM:
> Hi, > > Is there any compiler to Compile Embedded SQL Macros into source codes > for MySql? > In otherwords, what is the equivalent of PRO*C (in Oracle) in MySql? > > Thanks, > Ezhilarasan STORED PROCEDURES and FUNCTIONS are part of V5.x. http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html Before that you can compile your own functions (also known as User Defined Functions) by following the directions in the manual. These are actually compiled modules that you load into the running server or physical extensions that become part of the server itslef (they call these "native functions") Full details: http://dev.mysql.com/doc/refman/4.1/en/adding-functions.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine