Server: mysql.puroparty.com

Database: puroparty

Table: bd_world_cities

Structure Browse SQL Search Insert Export Operations Empty Drop

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	cityID	int(11)			No		auto_increment
	rID	int(4)			No	0
	cID	int(3)			No	0
	cityName	varchar(255)	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 cityID rID cID cityName

---

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 0  cityID cityID_2 UNIQUE 0  cityID rID_3 UNIQUE 0  rID cID_3 UNIQUE 0  cID cityName_2 UNIQUE 0  cityName cID_4 UNIQUE 0  cID cityName_4 UNIQUE 0  cityName rID_4 UNIQUE 0  rID cityID_3 UNIQUE 0  cityID cityID_6 UNIQUE 0  cityID rID_7 UNIQUE 0  rID cID_7 UNIQUE 0  cID cityName_8 UNIQUE 0  cityName rID_8 UNIQUE 0  rID cityName_12 UNIQUE 0  cityName cityID_8 UNIQUE 0  cityID cID_9 UNIQUE 0  cID cityName_13 UNIQUE 0  cityName rID_11 UNIQUE 0  rID cityID_9 UNIQUE 0  cityID rID_12 UNIQUE 0  rID cityID_10 UNIQUE 0  cityID cityName_18 UNIQUE 0  cityName cID_12 UNIQUE 0  cID cID_13 UNIQUE 0  cID cityID_13 UNIQUE 0  cityID rID_15 UNIQUE 0  rID cID_15 UNIQUE 0  cID cityName_20 UNIQUE 0  cityName rID INDEX None  rID cID cID INDEX None  cID cityID INDEX None  cityID rID_2 INDEX None  rID cID_2 INDEX None  cID cityName INDEX None  cityName cityName_5 INDEX None  cityName rID_5 INDEX None  rID cID_5 INDEX None  cID cityID_4 INDEX None  cityID cityID_5 INDEX None  cityID rID_6 INDEX None  rID cID_6 INDEX None  cID cityName_7 INDEX None  cityName cID_8 INDEX None  cID cityName_11 INDEX None  cityName cityID_7 INDEX None  cityID rID_9 INDEX None  rID cID_10 INDEX None  cID rID_10 INDEX None  rID cID_11 INDEX None  cID cityName_16 INDEX None  cityName cityName_17 INDEX None  cityName rID_13 INDEX None  rID cityID_11 INDEX None  cityID cityID_12 INDEX None  cityID rID_14 INDEX None  rID cID_14 INDEX None  cID cityName_19 INDEX None  cityName cityName_3 FULLTEXT None  cityName cityName_6 FULLTEXT None  cityName cityName_9 FULLTEXT None  cityName cityName_10 FULLTEXT None  cityName cityName_14 FULLTEXT None  cityName cityName_15 FULLTEXT None  cityName Create an index on  columns

Space usage:  Type Usage Data 0 Bytes Index 3,072 Bytes Total 3,072 Bytes

Row Statistic:  Statements Value Format dynamic Collation latin1_swedish_ci Rows 0 Next Autoindex 1 Creation Apr 13, 2018 at 06:39 PM Last update Mar 29, 2024 at 05:49 AM Last check Apr 19, 2024 at 08:36 AM

---

Run SQL query/queries on database puroparty		Fields:
SELECT * FROM `bd_world_cities` WHERE 1		cityID rID cID cityName
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