Server: mysql.puroparty.com

Database: puroparty

Table: email_subscribers_data

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 738304 kB

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	subscriberid	int(11)			No	0
	fieldid	int(11)			No	0
	data	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 subscriberid fieldid data

Indexes: Keyname Type Cardinality Action Field email_subscribers_data_subscriber_field_idx UNIQUE 883  subscriberid fieldid email_subscribers_data_data_idx INDEX 883  data 255 email_subscriber_data_field_subscriber_idx INDEX 883  fieldid subscriberid subscriberid INDEX 883  subscriberid fieldid INDEX 16  fieldid subscriberid_2 INDEX 883  subscriberid fieldid_2 INDEX 16  fieldid subscriberid_3 INDEX 883  subscriberid fieldid_3 INDEX 16  fieldid subscriberid_4 INDEX 883  subscriberid subscriberid_5 INDEX 883  subscriberid fieldid_4 INDEX 16  fieldid fieldid_5 INDEX 16  fieldid subscriberid_6 INDEX 883  subscriberid fieldid_6 INDEX 16  fieldid subscriberid_7 INDEX 883  subscriberid fieldid_7 INDEX 16  fieldid subscriberid_8 INDEX 883  subscriberid fieldid_8 INDEX 16  fieldid subscriberid_9 INDEX 883  subscriberid fieldid_9 INDEX 16  fieldid subscriberid_10 INDEX 883  subscriberid subscriberid_11 INDEX 883  subscriberid fieldid_10 INDEX 16  fieldid subscriberid_12 INDEX 883  subscriberid Create an index on  columns

Space usage:  Type Usage Data 65,536 Bytes Index 425,984 Bytes Total 491,520 Bytes

Row Statistic:  Statements Value Format dynamic Collation utf8_general_ci Creation Jun 27, 2018 at 06:23 AM

Run SQL query/queries on database puroparty		Fields:
SELECT * FROM `email_subscribers_data` WHERE 1		subscriberid fieldid data
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