Creating a stored procedure
delimiter / / create procedure
average (in town char)
begin select Nombre_Tore, Nickname, Tipo_Premio, Nombre_Plaza, address, city from natural
join Torero Plaza WHERE
Nombre_Tore = nickname;
end / / delimiter
;
CREATION of a function
select Nombre_Pla, Nombre_Gana, localidad_Gana INTO @ result
Livestock
natural join natural join WHERE Nombre_Pla
square = Livestock;
return @ result;
end / / delimiter
;
0 comments:
Post a Comment