Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: asLinks_categoriesasLinks_categories

   Field  Type Collation Attributes Null Default Extra Action
   smallint(10)   UNSIGNED No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   smallint(10)     No    Change Drop Primary Index Unique Fulltext
   smallint(10)     No    Change Drop Primary Index Unique Fulltext
   smallint(10)     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
id_3 UNIQUE Edit Drop id
id_6 UNIQUE Edit Drop id
id_8 UNIQUE Edit Drop id
id_10 UNIQUE Edit Drop id
id_12 UNIQUE Edit Drop id
id_14 UNIQUE Edit Drop id
id_15 UNIQUE Edit Drop id
id_17 UNIQUE Edit Drop id
name_2 UNIQUE None  Edit Drop name
name_5 UNIQUE None  Edit Drop name
name_8 UNIQUE None  Edit Drop name
name_11 UNIQUE None  Edit Drop name
name_14 UNIQUE None  Edit Drop name
name_17 UNIQUE None  Edit Drop name
name_20 UNIQUE None  Edit Drop name
id INDEX None  Edit Drop id
name INDEX None  Edit Drop name
parent INDEX None  Edit Drop parent
counter INDEX None  Edit Drop counter
subCategories INDEX None  Edit Drop subCategories
counter_2 INDEX None  Edit Drop counter
id_4 INDEX None  Edit Drop id
subCategories_2 INDEX None  Edit Drop subCategories
name_4 INDEX None  Edit Drop name
parent_2 INDEX None  Edit Drop parent
subCategories_3 INDEX None  Edit Drop subCategories
id_5 INDEX None  Edit Drop id
name_7 INDEX None  Edit Drop name
parent_3 INDEX None  Edit Drop parent
counter_3 INDEX None  Edit Drop counter
subCategories_4 INDEX None  Edit Drop subCategories
id_7 INDEX None  Edit Drop id
name_10 INDEX None  Edit Drop name
parent_4 INDEX None  Edit Drop parent
counter_4 INDEX None  Edit Drop counter
subCategories_5 INDEX None  Edit Drop subCategories
id_9 INDEX None  Edit Drop id
name_13 INDEX None  Edit Drop name
parent_5 INDEX None  Edit Drop parent
counter_5 INDEX None  Edit Drop counter
subCategories_6 INDEX None  Edit Drop subCategories
id_11 INDEX None  Edit Drop id
subCategories_7 INDEX None  Edit Drop subCategories
name_16 INDEX None  Edit Drop name
counter_6 INDEX None  Edit Drop counter
parent_6 INDEX None  Edit Drop parent
id_13 INDEX None  Edit Drop id
subCategories_8 INDEX None  Edit Drop subCategories
subCategories_9 INDEX None  Edit Drop subCategories
name_19 INDEX None  Edit Drop name
parent_7 INDEX None  Edit Drop parent
name_22 INDEX None  Edit Drop name
counter_7 INDEX None  Edit Drop counter
id_16 INDEX None  Edit Drop id
name_23 INDEX None  Edit Drop name
name_3 FULLTEXT None  Edit Drop name
name_6 FULLTEXT None  Edit Drop name
name_9 FULLTEXT None  Edit Drop name
name_12 FULLTEXT None  Edit Drop name
name_15 FULLTEXT None  Edit Drop name
name_18 FULLTEXT None  Edit Drop name
name_21 FULLTEXT None  Edit Drop name
Create an index on  columns  
 
Space usage: 
Type Usage
Data 152 Bytes
Index 3,072 Bytes
Total 3,224 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 6
Row length ø 25
Row size  ø 537 Bytes
Next Autoindex 9
Creation Mar 09, 2018 at 08:41 AM
Last update Mar 09, 2018 at 08:41 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: