3 rows where family = 052

View and edit SQL

id ▼ name family
0520012800 metra 2.0 Deutsche Leasing metra 2.0 Deutsche Leasing 052
0520013100 metra 3.0 Bosch Rexroth metra 2.0 Deutsche Leasing 052
0520013300 metra KUKA metra 2.0 Deutsche Leasing 052

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