INSERT INTO table1 (champ1) SELECT champ1 FROM table2;
CREATE FUNCTION maFunc(iMonParam INT) RETURNS INT BEGIN DECLARE iMaLocal INT; SET iMaLocal := 10 + iMonParam; RETURN iMaLocal; END; SELECT maFunc(10);
DELIMITER | CREATE PROCEDURE InsertChrono(pDateId INT, pResSubId INT, pNb INT) BEGIN WHILE pNb > 0 DO INSERT INTO ReservationChrono (ChronoDate, ChronoRes, ChronoNum) SELECT pDateId, pResSubId, IFNULL(MAX(ChronoNum)+1 ,1) FROM ReservationChrono WHERE ChronoDate=pDateId; SET pNb := pNb - 1; END WHILE; END
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionINSERT INTO ReservationChrono (ChronoDate, ChronoRes, ChronoNum) SELECT 1, 1, IFNULL(MAX(ChronoNum)+1,1) FROM ReservationChrono WHERE ChronoDate=1;
CREATE PROCEDURE InsertChrono(pDateId INT, pResSubId INT, pNb INT) BEGIN WHILE pNb > 0 DO INSERT INTO ReservationChrono (ChronoDate, ChronoRes, ChronoNum) SELECT pDateId, pResSubId, IFNULL(MAX(ChronoNum)+1 ,1) FROM ReservationChrono WHERE ChronoDate=pDateId; SET pNb = pNb - 1; END WHILE; END
CREATE PROCEDURE InsertChrono(IN pDateId INT, IN pResSubId INT, IN pNb INT) BEGIN DECLARE lCounter INT; SET lCounter=0; WHILE lCounter < pNb DO INSERT INTO ReservationChrono (ChronoDate, ChronoRes, ChronoNum) SELECT pDateId, pResSubId, IFNULL(MAX(ChronoNum)+1 ,1) FROM ReservationChrono WHERE ChronoDate=pDateId; SET lCounter = lCounter + 1; END WHILE; END