Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: bak_weblinksbak_weblinks
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0006 sec)
SQL-query: 
SELECT *
FROM `bak_weblinks`
PROCEDURE ANALYSE ( )
 [Edit] [Explain SQL] [Create PHP Code] [Refresh]


   Field  Type Collation Attributes Null Default Extra Action
   int(11)   UNSIGNED No    auto_increment  Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   varchar(250) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(250) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   datetime     No  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   datetime     No  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   text utf8_general_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 Edit Drop id
id_2 UNIQUE Edit Drop id
catid_3 UNIQUE Edit Drop catid
sid_2 UNIQUE Edit Drop sid
title_2 UNIQUE Edit Drop title
alias_2 UNIQUE Edit Drop alias
url_2 UNIQUE Edit Drop url
date_2 UNIQUE Edit Drop date
hits_2 UNIQUE Edit Drop hits
published_2 UNIQUE Edit Drop published
checked_out_2 UNIQUE Edit Drop checked_out
checked_out_time_2 UNIQUE Edit Drop checked_out_time
ordering_2 UNIQUE Edit Drop ordering
archived_2 UNIQUE Edit Drop archived
approved_2 UNIQUE Edit Drop approved
catid_4 UNIQUE Edit Drop catid
checked_out_time_3 UNIQUE Edit Drop checked_out_time
title_5 UNIQUE Edit Drop title
hits_4 UNIQUE Edit Drop hits
checked_out_3 UNIQUE Edit Drop checked_out
date_4 UNIQUE Edit Drop date
sid_4 UNIQUE Edit Drop sid
published_4 UNIQUE Edit Drop published
url_6 UNIQUE Edit Drop url
approved_3 UNIQUE Edit Drop approved
alias_5 UNIQUE Edit Drop alias
id_4 UNIQUE Edit Drop id
catid INDEX None  Edit Drop catid
published
archived
id INDEX None  Edit Drop id
catid_2 INDEX None  Edit Drop catid
sid INDEX None  Edit Drop sid
title INDEX None  Edit Drop title
alias INDEX None  Edit Drop alias
url INDEX None  Edit Drop url
date INDEX None  Edit Drop date
hits INDEX None  Edit Drop hits
published INDEX None  Edit Drop published
checked_out INDEX None  Edit Drop checked_out
checked_out_time INDEX None  Edit Drop checked_out_time
ordering INDEX None  Edit Drop ordering
archived INDEX None  Edit Drop archived
approved INDEX None  Edit Drop approved
ordering_3 INDEX None  Edit Drop ordering
hits_3 INDEX None  Edit Drop hits
date_3 INDEX None  Edit Drop date
id_3 INDEX None  Edit Drop id
catid_5 INDEX None  Edit Drop catid
sid_3 INDEX None  Edit Drop sid
archived_3 INDEX None  Edit Drop archived
url_4 INDEX None  Edit Drop url
published_3 INDEX None  Edit Drop published
title_6 INDEX None  Edit Drop title
alias_4 INDEX None  Edit Drop alias
checked_out_4 INDEX None  Edit Drop checked_out
title_3 FULLTEXT None  Edit Drop title
alias_3 FULLTEXT None  Edit Drop alias
url_3 FULLTEXT None  Edit Drop url
description FULLTEXT None  Edit Drop description
params FULLTEXT None  Edit Drop params
title_4 FULLTEXT None  Edit Drop title
url_5 FULLTEXT None  Edit Drop url
params_2 FULLTEXT None  Edit Drop params
description_2 FULLTEXT None  Edit Drop description
alias_6 FULLTEXT None  Edit Drop alias
Create an index on  columns  
 
Space usage: 
Type Usage
Data 0 Bytes
Index 4,096 Bytes
Total 4,096 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Rows 0
Next Autoindex 1
Creation Oct 23, 2017 at 11:22 AM
Last update Apr 08, 2018 at 12:18 AM
Last check Apr 08, 2018 at 12:18 AM

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: