Print Fill in the Blanks Game: Views y procedures BDAvanzada (formación de personal - sql - procedure

begin update procedure delete view delimiter IN select values

____________________ $$
create ____________________ sp_insert ( ____________________ pais_ varchar ( 50 ) ) ____________________ insert into paises ( pais ) ____________________ ( pais_ ) ;
end $$
delimiter ;

view update delete create drop as procedure from

____________________ ____________________ view_paises ____________________ select * ____________________ paises ;

drop join from ON delete in out view start

delimiter $$
create procedure sp_paises_estados ( )
begin
select pais , estado ____________________ paises inner ____________________ estados ____________________ estados . idpais = paises . idpais ;
end $$
delimiter ;

drop IN out select where from

delimiter $$
create procedure sp_eliminar ( ____________________ id int )
begin
delete ____________________ paises ____________________ idpais = id ;
end $$
delimiter ;

IN INTO FROM OUT

delimiter $$
create procedure sp_suma ( ____________________ suma int )
begin
select sum ( precio ) ____________________ suma ____________________ productos ;
end $$
delimiter ;

dateformat datediff for limit upper offset year by as on

delimiter $$
create procedure sp_listar ( )
begin
select ____________________ ( pais ) as pais , ____________________ ( fecha_publicacion ) ____________________ fecha from paises order ____________________ pais desc ____________________ 4 ;
end $$
delimiter ;