I am Using MYSQL (v5.8). I have a large table retailer that has lot of columns. "name" and "batch_date" are the columns I need to update on daily basis.
Now, I tried below SP to avoid duplicate entries for particular date.
"
CREATE PROCEDURE Management_Console.`USP_Qa_Retailer_Entry`()
BEGIN
IF EXISTS (Select * from qa_main.retailer where batch_date=DATE_ADD(CURDATE(), interval 1 day)
BEGIN
delete from retailer where batch_date=DATE_ADD(CURDATE(), interval 1) END;
ELSE
INSERT INTO qa_main.retailer(name,batch_date) SELECT name,
DATE_ADD(CURRENT_DATE(), INTERVAL 1 DAY) from
Management_Console.robot_schedule;
END IF;
END;
"
But I'm getting MySQL syntax error at IF EXISTS part. I tried with IF EXISTS ... THEN ... too, but of no use !! Could someone give me a solution for this ...
Aucun commentaire:
Enregistrer un commentaire