3 rows where family = 014

View and edit SQL

id ▼ name family
0140011700 CrossMedia CrossMedia 014
0140022000 CrossMedia II CrossMedia 014
0140022201 CrossMedia 3 CrossMedia 014

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