Completar Frases Views y procedures BDAvanzadaVersión en línea Estructura de views y procedures (mysql) por Dulce G 1 select procedure update view begin IN values delete delimiter $$ create sp_insert ( pais_ varchar ( 50 ) ) insert into paises ( pais ) ( pais_ ) ; end $$ delimiter ; 2 view as from create update procedure drop delete view_paises select * paises ; 3 drop in from ON delete start view out join delimiter $$ create procedure sp_paises_estados ( ) begin select pais , estado paises inner estados estados . idpais = paises . idpais ; end $$ delimiter ; 4 out IN where select from drop delimiter $$ create procedure sp_eliminar ( id int ) begin delete paises idpais = id ; end $$ delimiter ; 5 INTO IN OUT FROM delimiter $$ create procedure sp_suma ( suma int ) begin select sum ( precio ) suma productos ; end $$ delimiter ; 6 for datediff limit as year upper on by offset dateformat delimiter $$ create procedure sp_listar ( ) begin select ( pais ) as pais , ( fecha_publicacion ) fecha from paises order pais desc 4 ; end $$ delimiter ;
Crear