steven price
asked on
MYSQL Syntax Error
Hi
I get an "unexpected END_OF_INPUT, expected IF" error on the following MYSQL statement , can anyone help please
delimiter //
CREATE PROCEDURE UPDuserdaily (IN P_UserID INT,IN P_UserDate DATETIME)
BEGIN
IF NOT EXISTS (SELECT 1 FROM tbuserdaily WHERE UserID=P_UserID AND Date=P_UserDate) THEN
INSERT tbuserdaily(UserID,Date) VALUES (P_UserID,P_UserDate);
UPDATE tbuserdaily
SET Distance = (SELECT SUM(Distance) FROM tbjourney
WHERE UserID=P_UserID AND JourneyDateDate=P_UserDate )
WHERE UserID=P_UserID AND Date=P_UserDate;
END//
DELIMITER ;
I get an "unexpected END_OF_INPUT, expected IF" error on the following MYSQL statement , can anyone help please
delimiter //
CREATE PROCEDURE UPDuserdaily (IN P_UserID INT,IN P_UserDate DATETIME)
BEGIN
IF NOT EXISTS (SELECT 1 FROM tbuserdaily WHERE UserID=P_UserID AND Date=P_UserDate) THEN
INSERT tbuserdaily(UserID,Date) VALUES (P_UserID,P_UserDate);
UPDATE tbuserdaily
SET Distance = (SELECT SUM(Distance) FROM tbjourney
WHERE UserID=P_UserID AND JourneyDateDate=P_UserDate
WHERE UserID=P_UserID AND Date=P_UserDate;
END//
DELIMITER ;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.