Server: mysql.puroparty.com

Database: puroparty

Table: email_newsletters

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 738304 kB

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	newsletterid	int(11)			No		auto_increment
	name	varchar(255)	utf8_general_ci		Yes	NULL
	format	char(1)	utf8_general_ci		Yes	NULL
	subject	varchar(255)	utf8_general_ci		Yes	NULL
	textbody	longtext	utf8_general_ci		Yes	NULL
	htmlbody	longtext	utf8_general_ci		Yes	NULL
	createdate	int(11)			Yes	0
	active	int(11)			Yes	0
	archive	int(11)			Yes	0
	ownerid	int(11)			No	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 newsletterid name format subject textbody htmlbody createdate active archive ownerid

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 23  newsletterid newsletterid_2 UNIQUE 23  newsletterid newsletterid_3 UNIQUE 23  newsletterid newsletterid_6 UNIQUE 23  newsletterid newsletterid_7 UNIQUE 23  newsletterid newsletterid_10 UNIQUE 23  newsletterid newsletterid_12 UNIQUE 23  newsletterid newsletterid_14 UNIQUE 23  newsletterid name_2 UNIQUE 23  name name_3 UNIQUE 23  name name_6 UNIQUE 23  name name_7 UNIQUE 23  name name_10 UNIQUE 23  name email_newsletters_owner_idx INDEX 2  ownerid newsletterid INDEX 23  newsletterid name INDEX 23  name format INDEX 2  format subject INDEX 23  subject createdate INDEX 23  createdate active INDEX 4  active archive INDEX 2  archive ownerid INDEX 2  ownerid subject_2 INDEX 23  subject ownerid_2 INDEX 2  ownerid newsletterid_4 INDEX 23  newsletterid createdate_2 INDEX 23  createdate name_4 INDEX 23  name active_2 INDEX 4  active archive_2 INDEX 2  archive format_2 INDEX 2  format name_5 INDEX 23  name subject_3 INDEX 23  subject format_3 INDEX 2  format ownerid_3 INDEX 2  ownerid newsletterid_5 INDEX 23  newsletterid active_3 INDEX 4  active createdate_3 INDEX 23  createdate archive_3 INDEX 2  archive ownerid_4 INDEX 2  ownerid subject_4 INDEX 23  subject archive_4 INDEX 2  archive createdate_4 INDEX 23  createdate active_4 INDEX 4  active newsletterid_8 INDEX 23  newsletterid name_8 INDEX 23  name format_4 INDEX 2  format archive_5 INDEX 2  archive archive_6 INDEX 2  archive subject_5 INDEX 23  subject ownerid_5 INDEX 2  ownerid createdate_5 INDEX 23  createdate newsletterid_9 INDEX 23  newsletterid name_9 INDEX 23  name active_5 INDEX 4  active subject_6 INDEX 23  subject ownerid_6 INDEX 2  ownerid format_5 INDEX 2  format createdate_6 INDEX 23  createdate active_6 INDEX 4  active name_11 INDEX 23  name newsletterid_11 INDEX 23  newsletterid ownerid_7 INDEX 2  ownerid subject_7 INDEX 23  subject newsletterid_13 INDEX 23  newsletterid Create an index on  columns

Space usage:  Type Usage Data 147,456 Bytes Index 1,008 KB Total 1,152 KB

Row Statistic:  Statements Value Format dynamic Collation utf8_general_ci Next Autoindex 31 Creation Mar 29, 2024 at 11:53 AM

Run SQL query/queries on database puroparty		Fields:
SELECT * FROM `email_newsletters` WHERE 1		newsletterid name format subject textbody htmlbody createdate active archive ownerid
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