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?
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
DELIMITER ;
DROP PROCEDURE IF EXISTS