1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
|
FETCH c INTO idSoft,nomSoft,nb_tickets,nb_interruption,interruption_en_min,nb_degradation,dégradation_en_min;
IF done = 0 THEN
INSERT INTO vue(id,month,name,total_ticket ticket_Interuption,ticket_Interuption_en_min,ticket_degradation,ticket_degradation_en_min) VALUES (idSoft,nomSoft,nb_tickets,nb_interruption,interruption_en_min,nb_degradation,dégradation_en_min) ON DUPLICATE KEY UPDATE
id=idSoft,
name=nomSoft,
total_ticket=nb_tickets,
ticket_Interuption=nb_interruption,
ticket_Interuption_en_min=interruption_en_min,
ticket_degradation=nb_degradation,
ticket_degradation_en_min=dégradation_en_min;
END IF;
UNTIL done = 1 END REPEAT;
CLOSE c; |
Partager