Ejercicio 1 DELIMITER $$ DROP PROCEDURE IF EXISTS electronica.nuevofabricante $$ CREATE PROCEDURE electronica.nuevofabricanteI! no"bre #ARCAR%&'' (E)I! I!SERT I!TO fabricante* #ALUES!ULL+ no"bre', E!D $$ DELIMITER ,
Ejercicio 2 DELIMITER $$ DROP PROCEDURE IF EXISTS electronica.nuevoarticulo $$ CREATE PROCEDURE electronica.nuevoarticuloI! co- I!T+ I! articulo #ARCAR&'+ I! /v/ I!T' (E)I! I!SERT I!TO articulo* #ALUES!ULL+ articulo+ co-+ /v/+ 0&', E!D $$ DELIMITER ,
Ejercicio 3 DELIMITER $$ DROP PROCEDURE IF EXISTS electronica."in*toc1 $$ CREATE PROCEDURE electronica."in*toc1' (E)I! SELECT no"2fabricante+ no"bre+ /recio+ *toc1 FROM fabricante*+ articulo* 3ERE fab2i- 4 fabricante2iA!D *toc1 5 0&, E!D $$ DELIMITER ,
Ejercicio 4 DELIMITER $$ DROP PROCEDURE IF EXISTS electronica.*toc1 $$ CREATE PROCEDURE electronica.*toc1I! co- I!T' (E)I! SELECT *toc1 I!TO 6* FROM articulo* 3ERE articulo2i- 4 co-, SELECT no"bre I!TO 6n FROM articulo* 3ERE articulo2i- 4 co-, IF 6* 5 0& TE! SELECT 7E*te art8culo tiene "eno* -e 0& uni-a-e* en *toc17 I!TO 6t, ELSE SELECT 7E*te art8culo tiene "9* -e 0& uni-a-e* en *toc17 I!TO 6t, E!D IF, SELECT 6n+ 6t, E!D $$ DELIMITER ,
Ejercicio 5 DELIMITER $$ DROP PROCEDURE IF EXISTS electronica.nuevo/recio $$ CREATE PROCEDURE electronica.nuevo/recioI! co- I!T+ I! nuevo/recio I!T' (E)I! UPDATE articulo* SET /recio 4 nuevo/recio 3ERE articulo2i- 4 co-, E!D $$ DELIMITER ,
Ejercicio 6 DELIMITER $$ DROP PROCEDURE IF EXISTS electronica.borrafab $$ CREATE PROCEDURE electronica.borrafabI! co- I!T' (E)I! DELETE FROM articulo* 3ERE fab2i- 4 co-, DELETE FROM fabricante* 3ERE fabricante2i- 4 co-, E!D $$ DELIMITER ,
Ejercicio 7 DELIMITER $$ DROP PROCEDURE IF EXISTS electronica.actuali:a*toc1 $$ CREATE PROCEDURE electronica.actuali:a*toc1I! co- I!T+ I! canti-a- I!T' (E)I! SELECT *toc1 I!TO 6* FROM articulo* 3ERE articulo2i- 4 co-, SET 6* 4 6* ; canti-a-, UPDATE articulo* SET *toc1 4 6* 3ERE articulo2i- 4 co-, E!D $$ DELIMITER ,
Ejercicio 8 DELIMITER $$ DROP PROCEDURE IF EXISTS electronica."in/recio $$ CREATE PROCEDURE electronica."in/recioI! canti-a- I!T' (E)I! SELECT no"2fabricante+ no"bre+ /recio+ *toc1 FROM fabricante*+ articulo* 3ERE fab2i- 4 fabricante2iA!D /recio 5 canti-a-, E!D $$ DELIMITER ,