3 rows where family = 036

View and edit SQL

id ▼ name family
0360012700 MedienAnalyse Berlin 2007 print (intern) MedienAnalyse Berlin print 036
0360012701 MedienAnalyse Berlin 2007 print MedienAnalyse Berlin print 036
0360013000 Reichweitenstudie 2010 MedienAnalyse Berlin print 036

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)
);