Server: mysql.puroparty.com

Database: puroparty

Table: email_customfield_lists

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 737280 kB

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

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 9  cflid email_customfield_lists_field_list_idx UNIQUE 9  fieldid listid cflid_2 UNIQUE 9  cflid cflid_3 UNIQUE 9  cflid cflid_5 UNIQUE 9  cflid cflid_8 UNIQUE 9  cflid cflid_9 UNIQUE 9  cflid cflid_13 UNIQUE 9  cflid cflid_14 UNIQUE 9  cflid cflid_16 UNIQUE 9  cflid cflid INDEX 9  cflid fieldid INDEX 9  fieldid listid INDEX 9  listid fieldid_2 INDEX 9  fieldid listid_2 INDEX 9  listid cflid_4 INDEX 9  cflid fieldid_3 INDEX 9  fieldid cflid_6 INDEX 9  cflid listid_3 INDEX 9  listid cflid_7 INDEX 9  cflid fieldid_4 INDEX 9  fieldid listid_4 INDEX 9  listid fieldid_5 INDEX 9  fieldid cflid_10 INDEX 9  cflid listid_5 INDEX 9  listid fieldid_6 INDEX 9  fieldid cflid_11 INDEX 9  cflid fieldid_7 INDEX 9  fieldid listid_6 INDEX 9  listid cflid_12 INDEX 9  cflid cflid_15 INDEX 9  cflid fieldid_8 INDEX 9  fieldid listid_7 INDEX 9  listid listid_8 INDEX 9  listid fieldid_9 INDEX 9  fieldid fieldid_10 INDEX 9  fieldid Create an index on  columns

Space usage:  Type Usage Data 16,384 Bytes Index 573,440 Bytes Total 589,824 Bytes

Row Statistic:  Statements Value Format fixed Collation utf8_general_ci Next Autoindex 25 Creation Mar 29, 2024 at 05:05 AM

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