Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: usersusers
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0002 sec)
SQL-query: 
SELECT *
FROM `users`
WHERE CONVERT( `ip`
USING utf8 ) = '64.71.34.0'
LIMIT 0 , 30
 [Edit] [Explain SQL] [Create PHP Code] [Refresh]

StructureStructure BrowseBrowse SQLSQL SearchSearch InsertInsert ExportExport OperationsOperations EmptyEmpty DropDrop

   Field  Type Collation Attributes Null Default Extra Action
   varchar(15) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   int(11)     No  0    Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
With selected: Check All  /  Uncheck All     With selected:  
Print viewPrint view    Propose table structurePropose table structureDocumentation
Add new fieldAdd new field: 
Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 1  Edit Drop ip
ip_2 UNIQUE 1  Edit Drop ip
time_2 UNIQUE 1  Edit Drop time
ip_5 UNIQUE 1  Edit Drop ip
time_4 UNIQUE 1  Edit Drop time
time_6 UNIQUE 1  Edit Drop time
ip_9 UNIQUE 1  Edit Drop ip
ip_10 UNIQUE 1  Edit Drop ip
time_8 UNIQUE 1  Edit Drop time
ip_13 UNIQUE 1  Edit Drop ip
time_10 UNIQUE 1  Edit Drop time
ip_17 UNIQUE 1  Edit Drop ip
time_12 UNIQUE 1  Edit Drop time
ip_19 UNIQUE 1  Edit Drop ip
time_13 UNIQUE 1  Edit Drop time
ip_23 UNIQUE 1  Edit Drop ip
ip_26 UNIQUE 1  Edit Drop ip
time_15 UNIQUE 1  Edit Drop time
ip INDEX 1  Edit Drop ip
time INDEX 1  Edit Drop time
time_3 INDEX 1  Edit Drop time
ip_6 INDEX 1  Edit Drop ip
ip_7 INDEX 1  Edit Drop ip
time_5 INDEX 1  Edit Drop time
time_7 INDEX 1  Edit Drop time
ip_12 INDEX 1  Edit Drop ip
time_9 INDEX 1  Edit Drop time
ip_15 INDEX 1  Edit Drop ip
ip_16 INDEX 1  Edit Drop ip
time_11 INDEX 1  Edit Drop time
ip_20 INDEX 1  Edit Drop ip
time_14 INDEX 1  Edit Drop time
ip_24 INDEX 1  Edit Drop ip
time_16 INDEX 1  Edit Drop time
ip_27 INDEX 1  Edit Drop ip
ip_3 FULLTEXT 1  Edit Drop ip
url FULLTEXT 1  Edit Drop url
ip_4 FULLTEXT 1  Edit Drop ip
url_2 FULLTEXT 1  Edit Drop url
url_3 FULLTEXT 1  Edit Drop url
ip_8 FULLTEXT 1  Edit Drop ip
ip_11 FULLTEXT 1  Edit Drop ip
url_4 FULLTEXT 1  Edit Drop url
ip_14 FULLTEXT 1  Edit Drop ip
ip_18 FULLTEXT 1  Edit Drop ip
url_5 FULLTEXT 1  Edit Drop url
url_6 FULLTEXT 1  Edit Drop url
ip_21 FULLTEXT 1  Edit Drop ip
ip_22 FULLTEXT 1  Edit Drop ip
url_7 FULLTEXT 1  Edit Drop url
url_8 FULLTEXT 1  Edit Drop url
url_9 FULLTEXT 1  Edit Drop url
ip_25 FULLTEXT 1  Edit Drop ip
Create an index on  columns  
 
Space usage: 
Type Usage
Data 228 Bytes
Index 48,128 Bytes
Overhead 124 Bytes
Effective 48,232 Bytes
Total 48,356 Bytes
Optimize tableOptimize table
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 1
Row length ø 104
Row size  ø 48,356 Bytes
Creation May 01, 2024 at 09:01 AM
Last update May 02, 2024 at 04:08 PM
Last check May 01, 2024 at 06:26 PM
Run SQL query/queries on database puropartyDocumentation     Fields: 
Or Location of the textfile: 
 Location of the textfile: 
   (Max: 2,048KB)
  Compression:
                
Character set of the file: