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


   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(50) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(30) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   int(11)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   datetime     No  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   varchar(50) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   tinyint(3)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   int(11)     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
parent_id_2 UNIQUE Edit Drop parent_id
title_2 UNIQUE Edit Drop title
name_2 UNIQUE Edit Drop name
alias_2 UNIQUE Edit Drop alias
image_2 UNIQUE Edit Drop image
section_2 UNIQUE Edit Drop section
image_position_2 UNIQUE Edit Drop image_position
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
access_2 UNIQUE Edit Drop access
count_2 UNIQUE Edit Drop count
checked_out_3 UNIQUE Edit Drop checked_out
image_5 UNIQUE Edit Drop image
section_5 UNIQUE Edit Drop section
parent_id_4 UNIQUE Edit Drop parent_id
access_3 UNIQUE Edit Drop access
title_6 UNIQUE Edit Drop title
published_3 UNIQUE Edit Drop published
count_3 UNIQUE Edit Drop count
alias_5 UNIQUE Edit Drop alias
ordering_4 UNIQUE Edit Drop ordering
editor_2 UNIQUE None  Edit Drop editor
cat_idx INDEX None  Edit Drop section
published
access
idx_access INDEX None  Edit Drop access
idx_checkout INDEX None  Edit Drop checked_out
id INDEX None  Edit Drop id
parent_id INDEX None  Edit Drop parent_id
title INDEX None  Edit Drop title
name INDEX None  Edit Drop name
alias INDEX None  Edit Drop alias
image INDEX None  Edit Drop image
section INDEX None  Edit Drop section
image_position INDEX None  Edit Drop image_position
published INDEX None  Edit Drop published
checked_out INDEX None  Edit Drop checked_out
checked_out_time INDEX None  Edit Drop checked_out_time
editor INDEX None  Edit Drop editor
ordering INDEX None  Edit Drop ordering
access INDEX None  Edit Drop access
count INDEX None  Edit Drop count
checked_out_time_3 INDEX None  Edit Drop checked_out_time
section_4 INDEX None  Edit Drop section
parent_id_3 INDEX None  Edit Drop parent_id
ordering_3 INDEX None  Edit Drop ordering
title_5 INDEX None  Edit Drop title
title_3 FULLTEXT None  Edit Drop title
name_3 FULLTEXT None  Edit Drop name
alias_3 FULLTEXT None  Edit Drop alias
image_3 FULLTEXT None  Edit Drop image
section_3 FULLTEXT None  Edit Drop section
image_position_3 FULLTEXT None  Edit Drop image_position
description FULLTEXT None  Edit Drop description
editor_3 FULLTEXT None  Edit Drop editor
params FULLTEXT None  Edit Drop params
params_2 FULLTEXT None  Edit Drop params
image_4 FULLTEXT None  Edit Drop image
name_4 FULLTEXT None  Edit Drop name
title_4 FULLTEXT None  Edit Drop title
section_6 FULLTEXT None  Edit Drop section
alias_4 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 21, 2017 at 08:32 AM
Last update Apr 04, 2018 at 09:26 AM
Last check Apr 08, 2018 at 07:02 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: