download

SET @i = (SELECT MAX(id) + 1 FROM product);
INSERT INTO `product` (`name`, `slug`, `main_variant_id`, `main_category_id`, `status`) VALUES (CONCAT('Товар ', @i), CONCAT('tovar-',@i), null, 16, 1);
SET @product_id = LAST_INSERT_ID();
INSERT INTO `variant` (`name`, `slug`, `product_id`, `quantity`, `status`) VALUES ('main', 'main', @product_id, 99 ,1);
SET @variant_id = LAST_INSERT_ID();
UPDATE `product` SET `main_variant_id`= @variant_id WHERE id = @product_id;