DELIMITER // CREATE TRIGGER `test11` BEFORE UPDATE ON batch FOR EACH ROW BEGIN DECLARE proud Double; DECLARE result_position int; DECLARE result_all int; DECLARE date1 date; DECLARE cust varchar(100); SET @result_position = 1; DELETE FROM temp; SELECT COUNT(Batch_Date) INTO @result_all FROM batch WHERE Batch_date BETWEEN DATE_SUB(NOW(), INTERVAL 25 DAY) AND NOW() ; lab: LOOP PREPARE STMT FROM 'SELECT Batch_Date,Customer_Code,Production_Qty INTO @date1,@cust,@proud FROM batch WHERE Batch_date BETWEEN DATE_SUB(NOW(), INTERVAL 25 DAY) AND NOW() LIMIT ? , 1' ; EXECUTE STMT USING @result_position ; INSERT INTO temp (Batch_Date,Customer_Code,Production_Qty) VALUES(@date1,@cust,@proud); SET @result_position = @result_position + 1; if @result_position > @result_all then LEAVE lab; end if; END LOOP; END // DELIMITER ;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)