Server: mysql.puroparty.com

Database: puroparty

Table: email_banned_emails

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 739328 kB

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	banid	int(11)			No		auto_increment
	emailaddress	varchar(255)	utf8_general_ci		Yes	NULL
	list	varchar(10)	utf8_general_ci		Yes	NULL
	bandate	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 banid emailaddress list bandate

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 0  banid banid_2 UNIQUE 0  banid banid_3 UNIQUE 0  banid banid_6 UNIQUE 0  banid banid_8 UNIQUE 0  banid banid_9 UNIQUE 0  banid banid_11 UNIQUE 0  banid banid_14 UNIQUE 0  banid email_banned_emails_list_email_idx UNIQUE 0  list emailaddress emailaddress_2 UNIQUE 0  emailaddress list_2 UNIQUE 0  list bandate_2 UNIQUE 0  bandate list_3 UNIQUE 0  list emailaddress_3 UNIQUE 0  emailaddress bandate_3 UNIQUE 0  bandate emailaddress_5 UNIQUE 0  emailaddress bandate_5 UNIQUE 0  bandate list_6 UNIQUE 0  list emailaddress_8 UNIQUE 0  emailaddress list_8 UNIQUE 0  list bandate_8 UNIQUE 0  bandate emailaddress_9 UNIQUE 0  emailaddress list_9 UNIQUE 0  list bandate_9 UNIQUE 0  bandate emailaddress_11 UNIQUE 0  emailaddress list_11 UNIQUE 0  list emailaddress_12 UNIQUE 0  emailaddress list_14 UNIQUE 0  list bandate_11 UNIQUE 0  bandate bandate_12 UNIQUE 0  bandate emailaddress_15 UNIQUE 0  emailaddress list_16 UNIQUE 0  list bandate_14 UNIQUE 0  bandate emailaddress_16 UNIQUE 0  emailaddress banid INDEX 0  banid emailaddress INDEX 0  emailaddress list INDEX 0  list bandate INDEX 0  bandate emailaddress_4 INDEX 0  emailaddress list_4 INDEX 0  list banid_4 INDEX 0  banid bandate_4 INDEX 0  bandate list_5 INDEX 0  list banid_5 INDEX 0  banid bandate_6 INDEX 0  bandate emailaddress_6 INDEX 0  emailaddress banid_7 INDEX 0  banid emailaddress_7 INDEX 0  emailaddress list_7 INDEX 0  list bandate_7 INDEX 0  bandate emailaddress_10 INDEX 0  emailaddress list_10 INDEX 0  list banid_10 INDEX 0  banid bandate_10 INDEX 0  bandate list_12 INDEX 0  list list_13 INDEX 0  list emailaddress_13 INDEX 0  emailaddress banid_12 INDEX 0  banid banid_13 INDEX 0  banid emailaddress_14 INDEX 0  emailaddress list_15 INDEX 0  list bandate_13 INDEX 0  bandate banid_15 INDEX 0  banid bandate_15 INDEX 0  bandate 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 Next Autoindex 1 Creation Jun 23, 2018 at 02:14 PM

Run SQL query/queries on database puroparty		Fields:
SELECT * FROM `email_banned_emails` WHERE 1		banid emailaddress list bandate
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