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

   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 128  Edit Drop stat_my
stat_item INDEX Edit Drop stat_item
stat_detail INDEX 15  Edit Drop stat_detail
stat_count INDEX 277  Edit Drop stat_count
stat_my_3 INDEX 128  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 277  Edit Drop stat_count
stat_item_3 INDEX Edit Drop stat_item
stat_count_3 INDEX 277  Edit Drop stat_count
stat_detail_6 INDEX 15  Edit Drop stat_detail
stat_my_6 INDEX 128  Edit Drop stat_my
stat_my_7 INDEX 128  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 277  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 128  Edit Drop stat_my
stat_count_5 INDEX 277  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 277  Edit Drop stat_count
stat_my_11 INDEX 128  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 128  Edit Drop stat_my
stat_my_14 INDEX 128  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 277  Edit Drop stat_count
stat_count_8 INDEX 277  Edit Drop stat_count
stat_detail_18 INDEX 15  Edit Drop stat_detail
stat_item_9 INDEX Edit Drop stat_item
stat_my_17 INDEX 128  Edit Drop stat_my
stat_count_9 INDEX 277  Edit Drop stat_count
stat_detail_20 INDEX 15  Edit Drop stat_detail
stat_item_10 INDEX Edit Drop stat_item
stat_count_10 INDEX 277  Edit Drop stat_count
stat_my_19 INDEX 128  Edit Drop stat_my
stat_my_20 INDEX 128  Edit Drop stat_my
stat_detail_22 INDEX 15  Edit Drop stat_detail
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
stat_detail_17 FULLTEXT Edit Drop stat_detail
stat_my_16 FULLTEXT 11  Edit Drop stat_my
stat_detail_19 FULLTEXT Edit Drop stat_detail
stat_my_18 FULLTEXT 11  Edit Drop stat_my
stat_detail_21 FULLTEXT Edit Drop stat_detail
Create an index on  columns  
 
Space usage: 
Type Usage
Data 43,292 Bytes
Index 920,576 Bytes
Total 963,868 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 1,665
Row length ø 26
Row size  ø 579 Bytes
Creation Jun 21, 2018 at 04:07 PM
Last update Jun 21, 2018 at 07:55 PM
Last check Jun 21, 2018 at 04:07 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: