Server: mysql.puroparty.com

Database: puroparty

Table: photopost_sortmemb

Structure Browse SQL Search Insert Export Operations Empty Drop

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	sortid	int(15)			No		auto_increment
	name	varchar(35)	latin1_swedish_ci		No
	code	varchar(75)	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 sortid name code

---

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 4  sortid sortid_2 UNIQUE 4  sortid name_2 UNIQUE 4  name code_2 UNIQUE 4  code sortid_3 UNIQUE 4  sortid name_5 UNIQUE 4  name code_6 UNIQUE 4  code name_8 UNIQUE 4  name sortid_6 UNIQUE 4  sortid code_9 UNIQUE 4  code name_11 UNIQUE 4  name sortid_8 UNIQUE 4  sortid sortid_10 UNIQUE 4  sortid name_13 UNIQUE 4  name code_13 UNIQUE 4  code code_15 UNIQUE 4  code name_16 UNIQUE 4  name sortid_11 UNIQUE 4  sortid name_18 UNIQUE 4  name sortid_12 UNIQUE 4  sortid sortid INDEX 4  sortid name INDEX 4  name code INDEX 4  code name_4 INDEX 4  name code_5 INDEX 4  code sortid_4 INDEX 4  sortid name_7 INDEX 4  name code_7 INDEX 4  code sortid_5 INDEX 4  sortid code_10 INDEX 4  code name_10 INDEX 4  name sortid_7 INDEX 4  sortid sortid_9 INDEX 4  sortid name_12 INDEX 4  name code_12 INDEX 4  code name_17 INDEX 4  name code_16 INDEX 4  code name_3 FULLTEXT 4  name code_3 FULLTEXT 4  code code_4 FULLTEXT 4  code name_6 FULLTEXT 4  name code_8 FULLTEXT 4  code name_9 FULLTEXT 4  name code_11 FULLTEXT 4  code name_14 FULLTEXT 4  name code_14 FULLTEXT 4  code name_15 FULLTEXT 4  name code_17 FULLTEXT 4  code Create an index on  columns

Space usage:  Type Usage Data 196 Bytes Index 52,224 Bytes Total 52,420 Bytes

Row Statistic:  Statements Value Format dynamic Collation latin1_swedish_ci Rows 4 Row length ø 49 Row size  ø 13,105 Bytes Next Autoindex 5 Creation Apr 17, 2024 at 07:48 AM Last update Apr 18, 2024 at 07:08 AM Last check Apr 19, 2024 at 11:44 AM

---

Run SQL query/queries on database puroparty		Fields:
SELECT * FROM `photopost_sortmemb` WHERE 1		sortid name code
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