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 39  tpl_id tplset_id INDEX 5  tplset_id title INDEX 9  title tpl_id_3 INDEX 39  tpl_id title_3 INDEX 9  title tplset_id_2 INDEX 5  tplset_id tplset_id_3 INDEX 5  tplset_id tpl_id_5 INDEX 39  tpl_id title_5 INDEX 9  title tplset_id_4 INDEX 5  tplset_id tpl_id_8 INDEX 39  tpl_id title_7 INDEX 9  title tpl_id_9 INDEX 39  tpl_id tplset_id_5 INDEX 5  tplset_id title_9 INDEX 9  title tplset_id_6 INDEX 5  tplset_id tplset_id_7 INDEX 5  tplset_id title_2 FULLTEXT 9  title template FULLTEXT 39  template template_2 FULLTEXT 39  template title_4 FULLTEXT 9  title template_3 FULLTEXT 39  template title_6 FULLTEXT 9  title template_4 FULLTEXT 39  template title_8 FULLTEXT 9  title title_10 FULLTEXT 9  title template_5 FULLTEXT 39  template template_6 FULLTEXT 39  template Create an index on  columns

Space usage:  Type Usage Data 35,584 Bytes Index 135,168 Bytes Total 170,752 Bytes

Row Statistic:  Statements Value Format dynamic Collation latin1_swedish_ci Rows 39 Row length ø 912 Row size  ø 4,378 Bytes Next Autoindex 41 Creation Mar 29, 2024 at 02:12 AM Last update Mar 29, 2024 at 02:12 AM Last check Mar 31, 2024 at 07:29 PM

---

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