Server: mysql.puroparty.com

Database: puroparty

Table: poll_templates

Structure Browse SQL Search Insert Export Operations Empty Drop

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	tpl_id	int(10)		UNSIGNED	No		auto_increment
	tplset_id	int(10)		UNSIGNED	No	0
	title	varchar(100)	latin1_swedish_ci		No
	template	mediumtext	latin1_swedish_ci		No
Check All  /  Uncheck All     With selected:

---

Print view    Propose table structure

Add new field:  At End of Table At Beginning of Table After tpl_id tplset_id title template

---

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 39  tpl_id tpl_id_2 UNIQUE 39  tpl_id tpl_id_4 UNIQUE 39  tpl_id tpl_id_6 UNIQUE 39  tpl_id tpl_id_7 UNIQUE 39  tpl_id tpl_id_10 UNIQUE 39  tpl_id tpl_id INDEX None  tpl_id tplset_id INDEX None  tplset_id title INDEX None  title tpl_id_3 INDEX None  tpl_id title_3 INDEX None  title tplset_id_2 INDEX None  tplset_id tplset_id_3 INDEX None  tplset_id tpl_id_5 INDEX None  tpl_id title_5 INDEX None  title tplset_id_4 INDEX None  tplset_id tpl_id_8 INDEX None  tpl_id title_7 INDEX None  title tpl_id_9 INDEX None  tpl_id tplset_id_5 INDEX None  tplset_id title_9 INDEX None  title tplset_id_6 INDEX None  tplset_id tplset_id_7 INDEX None  tplset_id tpl_id_11 INDEX None  tpl_id title_2 FULLTEXT None  title template FULLTEXT None  template template_2 FULLTEXT None  template title_4 FULLTEXT None  title template_3 FULLTEXT None  template title_6 FULLTEXT None  title template_4 FULLTEXT None  template title_8 FULLTEXT None  title title_10 FULLTEXT None  title template_5 FULLTEXT None  template template_6 FULLTEXT None  template Create an index on  columns

Space usage:  Type Usage Data 35,584 Bytes Index 136,192 Bytes Total 171,776 Bytes

Row Statistic:  Statements Value Format dynamic Collation latin1_swedish_ci Rows 39 Row length ø 912 Row size  ø 4,405 Bytes Next Autoindex 41 Creation Apr 17, 2024 at 05:14 AM Last update Apr 17, 2024 at 05:14 AM

---

Run SQL query/queries on database puroparty		Fields:
SELECT * FROM `poll_templates` WHERE 1		tpl_id tplset_id title template
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