The code below keeps getting an error;
Go
Create PROC debo.PERSON_ID(
@ADMIS_ID INT= NULL,
@PERSON_ID INT(4)= NULL,
@DOCTOR_ID INT(4) = NULL,
@ADMIS_DATE DATE NOT NULL,
@DISCH_DATE DATE NOT NULL
AS
BEGIN
SET NOCOUNT ON
INSERT INTO HOSP_ADMIS ( ADMIS_ID, PERSON_ID, DOCTOR_ID, ADMIS_DATE,DISCH_DATE)
VALUES ( @ADMIS_ID, @PERSON_ID, @DOCTOR_ID,@ADMIS_DATE,
@DISCH_DATE);
END
GO
What I have tried:
Honestly, I’m trying different syntax but still clueless on how to fix the error. New to MySQL so it’s understandable but I’m stuck