Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
MySQL stored procedures (Read 2674 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
MySQL stored procedures
04.01.09 at 12:56:39
 
Call MySQL stored procedures
 
From MySQL version 5 stored procedures can be used in a database. The stored procedures as run using the call statement. Support for the CALL statement was added in SQL*XL version 4.3.12.
 
Syntax:
call stored_proc_name();
 
Stored procedures can be created and deleted using the create procedure and drop procedure commands. These commands were already supported.
 
Example:
As a simple example I have used a procedure to display hello world. The first command will drop any existing mysqlproc procedure. The second statement creates the procedure and the third command executes the stored procedure leading to the words hello world being output to Excel. Of course, once the procedure is created you can just run the call statement.
 
drop procedure mysqlproc;
create procedure mysqlproc() select 'hello world';
call mysqlproc();

 
 
References:
MySQL stored procedures  
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1225194834
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1