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


   Field  Type Collation Attributes Null Default Extra Action
   varchar(7) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   char(1) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(10) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   float(8,2)     No  0.00    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
stat_my INDEX 127  Edit Drop stat_my
stat_item INDEX Edit Drop stat_item
stat_detail INDEX 15  Edit Drop stat_detail
stat_count INDEX 275  Edit Drop stat_count
stat_my_3 INDEX 127  Edit Drop stat_my
stat_detail_4 INDEX 15  Edit Drop stat_detail
stat_item_2 INDEX Edit Drop stat_item
stat_count_2 INDEX 275  Edit Drop stat_count
stat_item_3 INDEX Edit Drop stat_item
stat_count_3 INDEX 275  Edit Drop stat_count
stat_detail_6 INDEX 15  Edit Drop stat_detail
stat_my_6 INDEX 127  Edit Drop stat_my
stat_my_7 INDEX 127  Edit Drop stat_my
stat_item_4 INDEX Edit Drop stat_item
stat_detail_7 INDEX 15  Edit Drop stat_detail
stat_count_4 INDEX 275  Edit Drop stat_count
stat_item_5 INDEX Edit Drop stat_item
stat_detail_9 INDEX 15  Edit Drop stat_detail
stat_my_10 INDEX 127  Edit Drop stat_my
stat_count_5 INDEX 275  Edit Drop stat_count
stat_detail_11 INDEX 15  Edit Drop stat_detail
stat_item_6 INDEX Edit Drop stat_item
stat_count_6 INDEX 275  Edit Drop stat_count
stat_my_11 INDEX 127  Edit Drop stat_my
stat_item_7 INDEX Edit Drop stat_item
stat_detail_13 INDEX 15  Edit Drop stat_detail
stat_my_12 INDEX 127  Edit Drop stat_my
stat_my_14 INDEX 127  Edit Drop stat_my
stat_item_8 INDEX Edit Drop stat_item
stat_detail_15 INDEX 15  Edit Drop stat_detail
stat_count_7 INDEX 275  Edit Drop stat_count
stat_count_8 INDEX 275  Edit Drop stat_count
stat_my_2 FULLTEXT 11  Edit Drop stat_my
stat_detail_2 FULLTEXT Edit Drop stat_detail
stat_detail_3 FULLTEXT Edit Drop stat_detail
stat_my_4 FULLTEXT 11  Edit Drop stat_my
stat_detail_5 FULLTEXT Edit Drop stat_detail
stat_my_5 FULLTEXT 11  Edit Drop stat_my
stat_my_8 FULLTEXT 11  Edit Drop stat_my
stat_detail_8 FULLTEXT Edit Drop stat_detail
stat_my_9 FULLTEXT 11  Edit Drop stat_my
stat_detail_10 FULLTEXT Edit Drop stat_detail
stat_detail_12 FULLTEXT Edit Drop stat_detail
stat_my_13 FULLTEXT 11  Edit Drop stat_my
stat_detail_14 FULLTEXT Edit Drop stat_detail
stat_my_15 FULLTEXT 11  Edit Drop stat_my
stat_detail_16 FULLTEXT Edit Drop stat_detail
Create an index on  columns  
 
Space usage: 
Type Usage
Data 42,980 Bytes
Index 680,960 Bytes
Total 723,940 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 1,651
Row length ø 26
Row size  ø 438 Bytes
Creation Apr 20, 2018 at 08:22 PM
Last update Apr 20, 2018 at 08:22 PM
Last check Apr 20, 2018 at 08: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: