Linker IT Software
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 2647 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.
call stored_proc_name();
Stored procedures can be created and deleted using the create procedure and drop procedure commands. These commands were already supported.
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();

MySQL stored procedures
Back to top

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