Hello:
Someone has a simple example to run a stored procedure/function of Mysql ?
Regards
[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;PD:
#xDefine Carpe_diem_quam_minimum_credula_postero "Aprovecha el dĂa, no confĂes en mañana"
>>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%")]
create Procedure Sp_Item(IN name varchar(25))//Here name is parameter
Begin
 select * from Item where Item.name=name;
 end;CALL Sp_Item('Computer');César & Sajith:
Thank you very much to both
I'll try it
Regards
CREATE FUNCTION `sf_hola`() RETURNS char(50)
RETURN('Hola !')It runs here!
How are you calling it?
CALL sf_hola('Armandito');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
Willi:
Muchas gracias por el ejemplo, ando buscando un ejemplo pero
de stored function.
Saludos
