3 rows where family = 071

View and edit SQL

id ▼ name family
0710003101 BrandSculpture Lindt 2011 BrandSculpture 071
0710003102 BrandSculpture Reemtsma 2011 BrandSculpture 071
0710003203 Brand Sculpture Automobile 2012 BrandSculpture 071

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE analysis (
	id VARCHAR(10) NOT NULL, 
	name VARCHAR(250), 
	family VARCHAR(3), 
	PRIMARY KEY (id), 
	UNIQUE (id), 
	FOREIGN KEY(family) REFERENCES families (id)
);