While-Schleife

[localhorst]

Code: Alles auswählen

CREATE PROCEDURE dowhile()
BEGIN
   DECLARE i INT DEFAULT 1;
   WHILE i < 64 DO
      IF (SELECT `remark` FROM `mystore2011_invoice` WHERE `id`=i) = "" THEN
         UPDATE `mystore2011_invoice` SET `remark`=NULL WHERE `id`=i;
      END IF;
      SET i = i + 1;
   END WHILE;
END