20 rows

View and edit SQL

id ▼ name publisher_id
1 Brand Community Network (BCN) brand-community-network-bcn
2 Brandstifter AG brandstifter-ag
3 DUS Airport Media dus-airport-media
4 Diverse diverse
5 Edgar Ambient Media Group GmbH edgar-ambient-media-group-gmbh
6 El Cartel Media el-cartel-media
7 Executive Channel Deutschland GmbH executive-channel-deutschland-gmbh
8 Flughafen Hamburg GmbH flughafen-hamburg-gmbh
9 Goldbach Germany goldbach-germany
10 Hygh Mobile Media GmbH hygh-mobile-media-gmbh
11 SK2 Solutions GmbH sk2-solutions-gmbh
12 Ströer stroer
13 TV Wartezimmer tv-wartezimmer
14 VIEWENTO GmbH viewento-gmbh
15 WallDecaux walldecaux
16 X-City Marketing x-city-marketing
17 airtango media GmbH airtango-media-gmbh
18 echion Corporate Communication AG echion-corporate-communication-ag
19 inovisco Mobile Media GmbH inovisco-mobile-media-gmbh
20 mcR&D mcr-d

Advanced export

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

CSV options:

CREATE TABLE publisher (
	id INTEGER NOT NULL, 
	name VARCHAR(250), 
	publisher_id VARCHAR(100), 
	PRIMARY KEY (id), 
	UNIQUE (id)
);
CREATE UNIQUE INDEX ix_publisher_publisher_id ON publisher (publisher_id);
CREATE UNIQUE INDEX ix_publisher_name ON publisher (name);