DECLARE random_price int;
DECLARE random_category int;
DECLARE random_stock int;
DECLARE i int DEFAULT 1;
WHILE i <= data_number DO
SET random_price = randomIntBetween(5,150);
SET random_category = randomIntBetween(78,80);
SET random_stock = randomIntBetween(0,1);
INSERT INTO products (name, price, categoryId, storeId, isInStock)
VALUES (CONCAT("product name ",i) , random_price , random_category , 1, random_stock);
SET i = i + 1;
END WHILE;