2 rows where family = 048

View and edit SQL

id ▼ name family
0480012800 TAMEDIA Autostudie 2008 Autostudie 048
0480013000 Tages-Anzeiger Autostudie 2010 Autostudie 048

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