add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
BrandName ClothesName VievingUrl Price
Brand1 Pants http://mysite.com?B=1&C=1 123.9900
Brand1 T-Shirt http://mysite.com?B=1&C=2 110.9900
Brand2 Pants http://mysite.com?B=2&C=1 75.9900
Brand2 T-Shirt http://mysite.com?B=2&C=2 85.9900
Skipping FOREIGN KEY constraint '#BrandsClothes' definition for temporary table. FOREIGN KEY constraints are not enforced on local or global temporary tables.
Skipping FOREIGN KEY constraint '#BrandsClothes' definition for temporary table. FOREIGN KEY constraints are not enforced on local or global temporary tables.
Skipping FOREIGN KEY constraint '#BCAttributes' definition for temporary table. FOREIGN KEY constraints are not enforced on local or global temporary tables.
Skipping FOREIGN KEY constraint '#BCAttributes' definition for temporary table. FOREIGN KEY constraints are not enforced on local or global temporary tables.
Skipping FOREIGN KEY constraint '#BCAttributes' definition for temporary table. FOREIGN KEY constraints are not enforced on local or global temporary tables.

ClothesName BrandName AttrName AttrValue
T-Shirt Brand1 Color Pearl, Black widow
T-Shirt Brand1 Size M, L, XL
T-Shirt Brand2 Custom 15% Discount
T-Shirt Brand2 Shape Slim fit, Regular fit
T-Shirt Brand2 Provider G-Star, Armani
ClothesName BrandName AttrName AttrValue
Pants Brand1 Size 32, 33, 34
T-Shirt Brand1 Size M, L, XL