Stored Procedure/Function of MySql

[Armando]

Hello:

Someone has a simple example to run a stored procedure/function of Mysql ?

Regards

[César E. Lozada]

You must pass the parameters:

Code: Select all

[SELECT * FROM CLIENTS WHERE State(CLIENTS.ADDRESS,"%WYOMING%")]

CREATE DEFINER = 'root'@'localhost' FUNCTION `State`(cAddress TEXT,cState TEXT)
    RETURNS tinyint(1)
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
  RETURN cAdress LIKE cState;
END;

Regards

PD:
#xDefine Carpe_diem_quam_minimum_credula_postero "Aprovecha el día, no confíes en mañana"
Thanks!

[Armando]

César:

Thanks a lot.

As I know your sample is to create the stored procedure, Now, how can I execute it ?

Regards

Code: Select all

PD:
#xDefine Carpe_diem_quam_minimum_credula_postero "Aprovecha el día, no confíes en mañana"
 

Return(.T.)

[César E. Lozada]

>>As I know your sample is to create the stored procedure, Now, how can I execute it ?

You can execute it only from a MySQL query:

[SELECT * FROM CLIENTS WHERE State(CLIENTS.ADDRESS,"%WYOMING%")]

[sajith]

Here is the sample to create and Execute StoredProcedure in Mysql

Code: Select all

create Procedure Sp_Item(IN name varchar(25))//Here name is parameter
Begin
 select * from Item where Item.name=name;
 end;

Command to Execute Procedure Sp_Item

Code: Select all

CALL Sp_Item('Computer');

Regards,
Sajith

[Armando]

César & Sajith:

Thank you very much to both

I'll try it

Regards

[Armando]

Dear Friends:

With your help I was able to create and execute a stored procedure successfully
thanks a lot for that, but I can't execute a STORED FUNCTION, is there a diference ?

Here is the code for my stored function

Code: Select all

CREATE FUNCTION `sf_hola`() RETURNS char(50)
RETURN('Hola !')
 

Regards

[César E. Lozada]

It runs here!

How are you calling it?

[Armando]

César:

This my code

Code: Select all

CALL sf_hola('Armandito');
 

The error message is "Procedure sf_hola does not exist"

And I use MySql 5.0.18

Regards

[Willi Quintana]

HI Maese.

//------------------
DELIMITER $$

DROP PROCEDURE IF EXISTS `cijmey`.`prueba` $$
CREATE PROCEDURE `cijmey`.`prueba` (IN cCodigo VARCHAR(20))
BEGIN
SELECT * FROM kardex WHERE cod_producto = cCodigo ;
END $$

DELIMITER ;
//---------
crealo cpon el Administrator del MySQL, con el Script

y lueco lo llamas con:

CALL prueba('CAS200065')


Salu2

[Armando]

Willi:

Muchas gracias por el ejemplo, ando buscando un ejemplo pero
de stored function.

Saludos