Server: mysql.puroparty.com

Database: puroparty

Table: users

Structure Browse SQL Search Insert Export Operations Empty Drop

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	ip	varchar(15)	latin1_swedish_ci		No
	time	int(11)			No	0
	url	text	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 ip time url

---

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 1  ip ip_2 UNIQUE 1  ip time_2 UNIQUE 1  time ip_5 UNIQUE 1  ip time_4 UNIQUE 1  time time_6 UNIQUE 1  time ip_9 UNIQUE 1  ip ip_10 UNIQUE 1  ip time_8 UNIQUE 1  time ip_13 UNIQUE 1  ip time_10 UNIQUE 1  time ip_17 UNIQUE 1  ip time_12 UNIQUE 1  time ip_19 UNIQUE 1  ip ip INDEX 1  ip time INDEX 1  time time_3 INDEX 1  time ip_6 INDEX 1  ip ip_7 INDEX 1  ip time_5 INDEX 1  time time_7 INDEX 1  time ip_12 INDEX 1  ip time_9 INDEX 1  time ip_15 INDEX 1  ip ip_16 INDEX 1  ip time_11 INDEX 1  time ip_3 FULLTEXT 1  ip url FULLTEXT 1  url ip_4 FULLTEXT 1  ip url_2 FULLTEXT 1  url url_3 FULLTEXT 1  url ip_8 FULLTEXT 1  ip ip_11 FULLTEXT 1  ip url_4 FULLTEXT 1  url ip_14 FULLTEXT 1  ip ip_18 FULLTEXT 1  ip url_5 FULLTEXT 1  url url_6 FULLTEXT 1  url Create an index on  columns

Space usage:  Type Usage Data 484 Bytes Index 34,816 Bytes Overhead 424 Bytes Effective 34,876 Bytes Total 35,300 Bytes Optimize table

Row Statistic:  Statements Value Format dynamic Collation latin1_swedish_ci Rows 1 Row length ø 60 Row size  ø 35,300 Bytes Creation Jun 24, 2018 at 05:17 AM Last update Apr 18, 2024 at 03:53 AM Last check Mar 21, 2024 at 08:11 PM

---

Run SQL query/queries on database puroparty		Fields:
SELECT * FROM `users` WHERE 1		ip time url
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