Server: mysql.puroparty.com

Database: puroparty

Table: email_list_subscribers_unsubscribe

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 737280 kB

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	subscriberid	int(11)			No	0
	unsubscribetime	int(11)			No	0
	unsubscribeip	varchar(20)	utf8_general_ci		Yes	NULL
	unsubscriberequesttime	int(11)			Yes	0
	unsubscriberequestip	varchar(20)	utf8_general_ci		Yes	NULL
	listid	int(11)			No	0
	statid	int(11)			Yes	0
	unsubscribearea	varchar(20)	utf8_general_ci		Yes	NULL
Check All  /  Uncheck All     With selected:

Print view

Relation view

Propose table structure

Add new field:  At End of Table At Beginning of Table After subscriberid unsubscribetime unsubscribeip unsubscriberequesttime unsubscriberequestip listid statid unsubscribearea

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 353  subscriberid subscriberid_2 UNIQUE 353  subscriberid unsubscribetime_2 UNIQUE 353  unsubscribetime unsubscribetime_4 UNIQUE 353  unsubscribetime subscriberid_3 UNIQUE 353  subscriberid subscriberid_5 UNIQUE 353  subscriberid unsubscribetime_6 UNIQUE 353  unsubscribetime subscriberid_8 UNIQUE 353  subscriberid unsubscribetime_8 UNIQUE 353  unsubscribetime unsubscribetime_9 UNIQUE 353  unsubscribetime subscriberid_9 UNIQUE 353  subscriberid subscriberid_12 UNIQUE 353  subscriberid unsubscribetime_12 UNIQUE 353  unsubscribetime email_list_unsubscribe_sub_list_idx INDEX 353  subscriberid listid email_list_subscribers_unsubscribe_statid_idx INDEX 58  statid subscriberid INDEX 353  subscriberid unsubscribetime INDEX 353  unsubscribetime unsubscribeip INDEX 353  unsubscribeip unsubscriberequesttime INDEX 2  unsubscriberequesttime unsubscriberequestip INDEX 2  unsubscriberequestip listid INDEX 20  listid statid INDEX 58  statid unsubscribearea INDEX 5  unsubscribearea unsubscriberequestip_2 INDEX 2  unsubscriberequestip unsubscriberequesttime_2 INDEX 2  unsubscriberequesttime unsubscribetime_3 INDEX 353  unsubscribetime statid_2 INDEX 58  statid subscriberid_4 INDEX 353  subscriberid listid_2 INDEX 20  listid unsubscribeip_2 INDEX 353  unsubscribeip unsubscribearea_2 INDEX 5  unsubscribearea statid_3 INDEX 58  statid unsubscribearea_3 INDEX 5  unsubscribearea unsubscribeip_3 INDEX 353  unsubscribeip unsubscriberequestip_3 INDEX 2  unsubscriberequestip subscriberid_6 INDEX 353  subscriberid unsubscriberequesttime_3 INDEX 2  unsubscriberequesttime listid_3 INDEX 20  listid unsubscribetime_5 INDEX 353  unsubscribetime unsubscribeip_4 INDEX 353  unsubscribeip unsubscribearea_4 INDEX 5  unsubscribearea statid_4 INDEX 58  statid subscriberid_7 INDEX 353  subscriberid unsubscriberequestip_4 INDEX 2  unsubscriberequestip unsubscriberequesttime_4 INDEX 2  unsubscriberequesttime unsubscriberequestip_5 INDEX 2  unsubscriberequestip listid_4 INDEX 20  listid unsubscribearea_5 INDEX 5  unsubscribearea unsubscribetime_7 INDEX 353  unsubscribetime statid_5 INDEX 58  statid unsubscribeip_5 INDEX 353  unsubscribeip unsubscriberequesttime_5 INDEX 2  unsubscriberequesttime listid_5 INDEX 20  listid unsubscribetime_10 INDEX 353  unsubscribetime subscriberid_10 INDEX 353  subscriberid unsubscriberequesttime_6 INDEX 2  unsubscriberequesttime unsubscribeip_6 INDEX 353  unsubscribeip subscriberid_11 INDEX 353  subscriberid unsubscribetime_11 INDEX 353  unsubscribetime unsubscribeip_7 INDEX 353  unsubscribeip unsubscriberequesttime_7 INDEX 2  unsubscriberequesttime unsubscriberequestip_6 INDEX 2  unsubscriberequestip listid_6 INDEX 20  listid statid_6 INDEX 58  statid Create an index on  columns

Space usage:  Type Usage Data 49,152 Bytes Index 1,008 KB Total 1,056 KB

Row Statistic:  Statements Value Format dynamic Collation utf8_general_ci Creation Jun 03, 2018 at 05:52 PM

Run SQL query/queries on database puroparty		Fields:
SELECT * FROM `email_list_subscribers_unsubscribe` WHERE 1		subscriberid unsubscribetime unsubscribeip unsubscriberequesttime unsubscriberequestip listid statid unsubscribearea
Show this query here again
Or Location of the textfile:
Location of the textfile:
(Max: 2,048KB)
Compression:      Autodetect   None   "gzipped"   "bzipped"
Character set of the file: armscii8 ascii big5 binary cp1250 cp1251 cp1256 cp1257 cp850 cp852 cp866 cp932 dec8 euckr gb2312 gbk geostd8 greek hebrew hp8 keybcs2 koi8r koi8u latin1 latin2 latin5 latin7 macce macroman sjis swe7 tis620 ucs2 ujis utf8