Server: mysql.puroparty.com

Database: puroparty

Table: djs

Structure Browse SQL Search Insert Export Operations Empty Drop

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	id	smallint(4)			No		auto_increment
	name	varchar(50)	latin1_swedish_ci		No
	phone1	varchar(15)	latin1_swedish_ci		No
	phone2	varchar(15)	latin1_swedish_ci		No
	type	varchar(50)	latin1_swedish_ci		No
	website	varchar(50)	latin1_swedish_ci		No
	location	varchar(35)	latin1_swedish_ci		No
	smallpic	varchar(35)	latin1_swedish_ci		No
	largepic	varchar(35)	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 id name phone1 phone2 type website location smallpic largepic

---

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 13  id id_2 UNIQUE 13  id name_2 UNIQUE 13  name smallpic_2 UNIQUE 13  smallpic largepic_2 UNIQUE 13  largepic id_3 UNIQUE 13  id name_5 UNIQUE 13  name largepic_6 UNIQUE 13  largepic smallpic_6 UNIQUE 13  smallpic name_7 UNIQUE 13  name id_6 UNIQUE 13  id smallpic_7 UNIQUE 13  smallpic largepic_8 UNIQUE 13  largepic id INDEX None  id name INDEX None  name phone1 INDEX None  phone1 phone2 INDEX None  phone2 type INDEX None  type website INDEX None  website location INDEX None  location smallpic INDEX None  smallpic largepic INDEX None  largepic location_3 INDEX None  location type_3 INDEX None  type website_3 INDEX None  website name_6 INDEX None  name largepic_4 INDEX None  largepic smallpic_5 INDEX None  smallpic phone2_4 INDEX None  phone2 id_4 INDEX None  id phone1_3 INDEX None  phone1 phone1_5 INDEX None  phone1 phone2_5 INDEX None  phone2 id_5 INDEX None  id name_8 INDEX None  name website_6 INDEX None  website location_6 INDEX None  location type_5 INDEX None  type smallpic_9 INDEX None  smallpic largepic_9 INDEX None  largepic name_3 FULLTEXT None  name phone1_2 FULLTEXT None  phone1 phone2_2 FULLTEXT None  phone2 type_2 FULLTEXT None  type website_2 FULLTEXT None  website location_2 FULLTEXT None  location smallpic_3 FULLTEXT None  smallpic largepic_3 FULLTEXT None  largepic smallpic_4 FULLTEXT None  smallpic location_4 FULLTEXT None  location name_4 FULLTEXT None  name phone2_3 FULLTEXT None  phone2 largepic_5 FULLTEXT None  largepic website_4 FULLTEXT None  website type_4 FULLTEXT None  type phone1_4 FULLTEXT None  phone1 location_5 FULLTEXT None  location largepic_7 FULLTEXT None  largepic phone2_6 FULLTEXT None  phone2 phone1_6 FULLTEXT None  phone1 smallpic_8 FULLTEXT None  smallpic website_5 FULLTEXT None  website name_9 FULLTEXT None  name type_6 FULLTEXT None  type Create an index on  columns

Space usage:  Type Usage Data 1,516 Bytes Index 3,072 Bytes Total 4,588 Bytes

Row Statistic:  Statements Value Format dynamic Collation latin1_swedish_ci Rows 13 Row length ø 116 Row size  ø 353 Bytes Next Autoindex 14 Creation Oct 30, 2017 at 04:24 PM Last update Jun 09, 2018 at 12:20 PM Last check Mar 18, 2024 at 10:30 PM

---

Run SQL query/queries on database puroparty		Fields:
ALTER TABLE `djs` ADD INDEX(`phone2`)		id name phone1 phone2 type website location smallpic largepic
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