Wpis z mikrobloga

DELIMITER ;

DROP PROCEDURE IF EXISTS generate_discount_codes;

DELIMITER //
CREATE PROCEDURE generate_discount_codes(IN quantity INT(8), IN discount INT(8), IN date_start DATE, IN date_end DATE, IN coupon_group_id INT(8))
BEGIN
DECLARE cuopon_code VARCHAR(10);
DECLARE old_code VARCHAR(10);
DECLARE i INT(8) DEFAULT 0;

WHILE (i <= quantity) DO
END WHILE;
END//

DELIMITER ;

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END WHILE;
END' at line

Co to za cholerstwo? Dlaczego wywala mi błąd w linijce END WHILE?

#mysql #sql
  • 4
  • Odpowiedz