DELIMITER $$
DROP PROCEDURE IF EXISTS CALTOTAL$$
CREATE PROCEDURE CALTOTAL()
BEGIN
 DECLARE UFE TINYINT DEFAULT 0;
 DECLARE C TINYINT;
 DECLARE TTOTAL NUMERIC(15,2);
 DECLARE C1 CURSOR FOR SELECT CodigoPedido, SUM(cantidad*preciounidad) FROM detallepedido GROUP BY codigopedido
 DECLARE CONTINUE HANDLER FOR NOT FOUND SET UFE=1;
 OPEN C1;
  FETCH C1 INTO C,TTOTAL ;
  WHILE NOT UFE DO
    UPDATE pedido SET total = TTOTAL WHERE codigopedido = C;
  FETCH C1 INTO C,TTOTAL;
  END WHILE;
 CLOSE C1;

END$$
DELIMITER ;