Question

write a script that creates and calls a stored procedure named test. this procedure should attempt to update the invoice_due_date column so it's equal th null for the invoice with an invoice id of 1

Answer 1

-- return message if category not insert successfully

-- message in array with msg key

DELIMITER $$

CREATE PROCEDURE mycheck6 (IN name varchar(50))

BEGIN

                -- return message if category not insert successfully

                DECLARE CONTINUE HANDLER FOR 1062

     SELECT CONCAT('Row was not inserted - duplicate entry.') AS msg;

    

     -- insert a new category name

     insert into categories2 (name) values (name);

    

     -- return message if insert successfully

     SELECT CONCAT('1 row was inserted.') AS msg;

               

   

END$$

DELIMITER ;

--Some other example here

-- in this example you set error message according to SIGNAL SQLSTATE '45000'

DELIMITER $$

CREATE PROCEDURE mycheck (IN name varchar(50))

BEGIN

                insert into categories2 (name) values (name);

                IF ROW_COUNT() > 0

    then

                SIGNAL SQLSTATE '45000'

                SET MESSAGE_TEXT = "1 row was inserted.";

                else

                                SIGNAL SQLSTATE '45000'

                SET MESSAGE_TEXT = "Row was not inserted - duplicate entry.";

                end if;

END$$

DELIMITER ;