Server: mysql.puroparty.com

Database: puroparty

Table: email_stats_linkclicks

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 737280 kB

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	clickid	int(11)			No		auto_increment
	clicktime	int(11)			Yes	0
	clickip	varchar(20)	utf8_general_ci		Yes	NULL
	subscriberid	int(11)			Yes	0
	statid	int(11)			Yes	0
	linkid	int(11)			Yes	0
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 clickid clicktime clickip subscriberid statid linkid

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 3760  clickid clickid_2 UNIQUE 3760  clickid clickid_4 UNIQUE 3760  clickid clickid_5 UNIQUE 3760  clickid clickid_7 UNIQUE 3760  clickid clickid_9 UNIQUE 3760  clickid clickid_12 UNIQUE 3760  clickid clickid_13 UNIQUE 3760  clickid clickid_15 UNIQUE 3760  clickid email_stats_linkclicks_subscriberid_idx INDEX 3760  subscriberid email_stats_linkclicks_statid_idx INDEX 83  statid email_stats_linkclicks_linkid_idx INDEX 68  linkid email_stats_linkclicks_subscriberid INDEX 3760  subscriberid clickid INDEX 3760  clickid clicktime INDEX 3760  clicktime clickip INDEX 3760  clickip subscriberid INDEX 3760  subscriberid statid INDEX 83  statid linkid INDEX 67  linkid clickip_2 INDEX 3760  clickip clickid_3 INDEX 3760  clickid statid_2 INDEX 72  statid clicktime_2 INDEX 3760  clicktime subscriberid_2 INDEX 3760  subscriberid linkid_2 INDEX 67  linkid clickip_3 INDEX 3760  clickip linkid_3 INDEX 68  linkid statid_3 INDEX 83  statid subscriberid_3 INDEX 3760  subscriberid clicktime_3 INDEX 3760  clicktime clickid_6 INDEX 3760  clickid linkid_4 INDEX 67  linkid clickip_4 INDEX 3760  clickip clicktime_4 INDEX 3760  clicktime subscriberid_4 INDEX 3760  subscriberid clickid_8 INDEX 3760  clickid linkid_5 INDEX 67  linkid clickip_5 INDEX 3760  clickip statid_4 INDEX 83  statid subscriberid_5 INDEX 3760  subscriberid clicktime_5 INDEX 3760  clicktime statid_5 INDEX 83  statid clickid_10 INDEX 3760  clickid linkid_6 INDEX 67  linkid clickid_11 INDEX 3760  clickid clicktime_6 INDEX 3760  clicktime clickip_6 INDEX 3760  clickip subscriberid_6 INDEX 3760  subscriberid statid_6 INDEX 83  statid linkid_7 INDEX 67  linkid linkid_8 INDEX 68  linkid statid_7 INDEX 75  statid subscriberid_7 INDEX 3760  subscriberid clicktime_7 INDEX 3760  clicktime linkid_9 INDEX 67  linkid clickip_7 INDEX 3760  clickip clickid_14 INDEX 3760  clickid statid_8 INDEX 78  statid subscriberid_8 INDEX 3760  subscriberid clicktime_8 INDEX 3760  clicktime linkid_10 INDEX 67  linkid clickid_16 INDEX 3760  clickid clickip_8 INDEX 3760  clickip clickid_17 INDEX 3760  clickid Create an index on  columns

Space usage:  Type Usage Data 294,912 Bytes Index 7,152 KB Total 7,440 KB

Row Statistic:  Statements Value Format dynamic Collation utf8_general_ci Next Autoindex 3,939 Creation Mar 28, 2024 at 02:21 PM

Run SQL query/queries on database puroparty		Fields:
SELECT * FROM `email_stats_linkclicks` WHERE 1		clickid clicktime clickip subscriberid statid linkid
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