I tried a simple app for testing but doesn't get the value on my table.
what I am doing wrong?
I want just put a value in a variable (not default) and then from the variable put it on the table.
like so
CREATE DEFINER=`mysql`@`localhost`
PROCEDURE `calcularferiado`(
in StartDate date,
in EndDate date,
in Duration int)
BEGIN
DECLARE DateDiff1 Int;
SELECT DateDiff1 = DATEDIFF(StartDate,EndDate);
INSERT INTO my_schema.feriados(inicio,fin,activo)
values (StartDate, EndDate, DateDiff1);
END
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…