Server: mysql.puroparty.com

Database: puroparty

Table: email_queues_unsent

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 737280 kB

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	recipient	int(11)			No	0
	queueid	int(11)			Yes	0
	reasoncode	int(11)			Yes	0
	reason	text	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 recipient queueid reasoncode reason

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 2  recipient recipient_2 UNIQUE 2  recipient recipient_4 UNIQUE 2  recipient recipient_6 UNIQUE 2  recipient recipient_8 UNIQUE 2  recipient recipient_10 UNIQUE 2  recipient recipient_12 UNIQUE 2  recipient queueid_2 UNIQUE 2  queueid queueid_4 UNIQUE 2  queueid queueid_6 UNIQUE 2  queueid queueid_8 UNIQUE 2  queueid queueid_11 UNIQUE 2  queueid queueid_12 UNIQUE 2  queueid recipient INDEX 2  recipient queueid INDEX 2  queueid reasoncode INDEX 2  reasoncode reasoncode_2 INDEX 2  reasoncode queueid_3 INDEX 2  queueid recipient_3 INDEX 2  recipient recipient_5 INDEX 2  recipient reasoncode_3 INDEX 2  reasoncode queueid_5 INDEX 2  queueid recipient_7 INDEX 2  recipient queueid_7 INDEX 2  queueid reasoncode_4 INDEX 2  reasoncode recipient_9 INDEX 2  recipient reasoncode_5 INDEX 2  reasoncode queueid_9 INDEX 2  queueid recipient_11 INDEX 2  recipient queueid_10 INDEX 2  queueid reasoncode_6 INDEX 2  reasoncode Create an index on  columns

Space usage:  Type Usage Data 16,384 Bytes Index 491,520 Bytes Total 507,904 Bytes

Row Statistic:  Statements Value Format dynamic Collation utf8_general_ci Creation Apr 21, 2018 at 07:34 AM

Run SQL query/queries on database puroparty		Fields:
SELECT * FROM `email_queues_unsent` WHERE 1		recipient queueid reasoncode reason
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