BEGIN DECLARE x INT; SET x = 1; WHILE x <= 5 DO INSERT INTO PRODUCTS (CategoryID, ModelNumber, ModelName, ProductImage, UnitCost, Description) VALUES (x, x, x, x, x, x); SET x = x + 1; END WHILE; END
And Run it.
BEGIN DECLARE x INT; SET x = 1; WHILE x <= 5 DO INSERT INTO PRODUCTS (CategoryID, ModelNumber, ModelName, ProductImage, UnitCost, Description) VALUES (x, x, x, x, x, x); SET x = x + 1; END WHILE; END
No comments:
Post a Comment