Server: mysql.puroparty.com

Database: puroparty

Table: email_stats_autoresponders_recipients

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 739328 kB

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	statid	int(11)			No	0
	autoresponderid	int(11)			Yes	0
	send_status	char(1)	utf8_general_ci		Yes	NULL
	recipient	int(11)			Yes	0
	reason	varchar(20)	utf8_general_ci		Yes	NULL
	sendtime	int(11)			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 statid autoresponderid send_status recipient reason sendtime

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 0  statid statid_2 UNIQUE 0  statid statid_4 UNIQUE 0  statid statid_6 UNIQUE 0  statid statid_8 UNIQUE 0  statid statid_9 UNIQUE 0  statid statid_11 UNIQUE 0  statid autoresponderid_2 UNIQUE 0  autoresponderid send_status_2 UNIQUE 0  send_status recipient_2 UNIQUE 0  recipient reason_2 UNIQUE 0  reason sendtime_2 UNIQUE 0  sendtime reason_4 UNIQUE 0  reason send_status_4 UNIQUE 0  send_status recipient_4 UNIQUE 0  recipient autoresponderid_4 UNIQUE 0  autoresponderid sendtime_4 UNIQUE 0  sendtime send_status_5 UNIQUE 0  send_status sendtime_5 UNIQUE 0  sendtime reason_5 UNIQUE 0  reason recipient_6 UNIQUE 0  recipient autoresponderid_5 UNIQUE 0  autoresponderid send_status_7 UNIQUE 0  send_status reason_7 UNIQUE 0  reason recipient_8 UNIQUE 0  recipient sendtime_7 UNIQUE 0  sendtime sendtime_9 UNIQUE 0  sendtime autoresponderid_8 UNIQUE 0  autoresponderid recipient_10 UNIQUE 0  recipient send_status_10 UNIQUE 0  send_status autoresponderid_10 UNIQUE 0  autoresponderid reason_10 UNIQUE 0  reason send_status_11 UNIQUE 0  send_status email_stats_autoresponders_recipients_stat_auto_recip INDEX 0  statid autoresponderid recipient statid INDEX 0  statid autoresponderid INDEX 0  autoresponderid send_status INDEX 0  send_status recipient INDEX 0  recipient reason INDEX 0  reason sendtime INDEX 0  sendtime autoresponderid_3 INDEX 0  autoresponderid statid_3 INDEX 0  statid recipient_3 INDEX 0  recipient reason_3 INDEX 0  reason send_status_3 INDEX 0  send_status sendtime_3 INDEX 0  sendtime send_status_6 INDEX 0  send_status statid_5 INDEX 0  statid recipient_5 INDEX 0  recipient sendtime_6 INDEX 0  sendtime autoresponderid_6 INDEX 0  autoresponderid reason_6 INDEX 0  reason statid_7 INDEX 0  statid recipient_7 INDEX 0  recipient send_status_8 INDEX 0  send_status sendtime_8 INDEX 0  sendtime reason_8 INDEX 0  reason send_status_9 INDEX 0  send_status recipient_9 INDEX 0  recipient autoresponderid_7 INDEX 0  autoresponderid sendtime_10 INDEX 0  sendtime autoresponderid_9 INDEX 0  autoresponderid reason_9 INDEX 0  reason statid_10 INDEX 0  statid Create an index on  columns

Space usage:  Type Usage Data 16,384 Bytes Index 1,008 KB Total 1,024 KB

Row Statistic:  Statements Value Format dynamic Collation utf8_general_ci Creation Apr 15, 2018 at 11:25 PM

Run SQL query/queries on database puroparty		Fields:
SELECT * FROM `email_stats_autoresponders_recipients` WHERE 1		statid autoresponderid send_status recipient reason sendtime
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