Stored procedure

rman

Hi everybody,

I want to know if we can create directly Mysql's stored procedures through the wizard which create the report dataset

if it's possible, what is the right syntax.

thanks for your help.

felijas

Tianli

Yes you can, just input the Query like:
CREATE PROCEDURE sptesting
(IN p1 INTEGER)
BEGIN
/* define procedure here */
END;
and then finish the dataset creating, the query will be executed.

For doublecheck, in MySQL command line client input:
show create procedure sptesting;
you will see the sptesing show in mysql command line client.

But I think the query like insert, updated and create are not recommended in dataset editor.