Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: wp_7_term_relationshipswp_7_term_relationships
An index has been added on term_order (Query took 0.0138 sec)
SQL-query: 
ALTER TABLE `wp_7_term_relationships` ADD INDEX ( `term_order` )
 [Edit] [Create PHP Code]


   Field  Type Collation Attributes Null Default Extra Action
   bigint(20)     No    Change Drop Primary Index Unique Fulltext
   bigint(20)     No    Change Drop Primary Index Unique Fulltext
   int(11)     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 19  Edit Drop object_id
term_taxonomy_id
term_taxonomy_id INDEX None  Edit Drop term_taxonomy_id
object_id INDEX None  Edit Drop object_id
term_taxonomy_id_2 INDEX None  Edit Drop term_taxonomy_id
term_order INDEX None  Edit Drop term_order
object_id_2 INDEX None  Edit Drop object_id
term_taxonomy_id_3 INDEX None  Edit Drop term_taxonomy_id
term_order_2 INDEX None  Edit Drop term_order
term_taxonomy_id_4 INDEX None  Edit Drop term_taxonomy_id
object_id_3 INDEX None  Edit Drop object_id
term_order_3 INDEX None  Edit Drop term_order
term_order_4 INDEX None  Edit Drop term_order
term_taxonomy_id_5 INDEX None  Edit Drop term_taxonomy_id
object_id_4 INDEX None  Edit Drop object_id
term_taxonomy_id_6 INDEX None  Edit Drop term_taxonomy_id
term_order_5 INDEX None  Edit Drop term_order
object_id_5 INDEX None  Edit Drop object_id
term_order_6 INDEX None  Edit Drop term_order
Create an index on  columns  
 
Space usage: 
Type Usage
Data 399 Bytes
Index 20,480 Bytes
Total 20,879 Bytes
 
Row Statistic: 
Statements Value
Format fixed
Collation utf8_general_ci
Rows 19
Row length ø 21
Row size  ø 1,099 Bytes
Creation Jun 19, 2018 at 06:22 PM
Last update Jun 19, 2018 at 06:22 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: