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


InnoDB free: 781312 kB

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   varchar(20) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
With selected: Check All  /  Uncheck All     With selected:  

Print viewPrint view    Relation viewRelation view    Propose table structurePropose table structureDocumentation
Add new fieldAdd new field: 

Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 3753  Edit Drop clickid
clickid_2 UNIQUE 3753  Edit Drop clickid
clickid_4 UNIQUE 3753  Edit Drop clickid
clickid_5 UNIQUE 3753  Edit Drop clickid
clickid_7 UNIQUE 3753  Edit Drop clickid
clickid_9 UNIQUE 3753  Edit Drop clickid
clickid_12 UNIQUE 3753  Edit Drop clickid
email_stats_linkclicks_subscriberid_idx INDEX 3753  Edit Drop subscriberid
email_stats_linkclicks_statid_idx INDEX 56  Edit Drop statid
email_stats_linkclicks_linkid_idx INDEX 68  Edit Drop linkid
email_stats_linkclicks_subscriberid INDEX 3753  Edit Drop subscriberid
clickid INDEX 3753  Edit Drop clickid
clicktime INDEX 3753  Edit Drop clicktime
clickip INDEX 3753  Edit Drop clickip
subscriberid INDEX 3753  Edit Drop subscriberid
statid INDEX 56  Edit Drop statid
linkid INDEX 68  Edit Drop linkid
clickip_2 INDEX 3753  Edit Drop clickip
clickid_3 INDEX 3753  Edit Drop clickid
statid_2 INDEX 70  Edit Drop statid
clicktime_2 INDEX 3753  Edit Drop clicktime
subscriberid_2 INDEX 3753  Edit Drop subscriberid
linkid_2 INDEX 68  Edit Drop linkid
clickip_3 INDEX 3753  Edit Drop clickip
linkid_3 INDEX 68  Edit Drop linkid
statid_3 INDEX 60  Edit Drop statid
subscriberid_3 INDEX 3753  Edit Drop subscriberid
clicktime_3 INDEX 3753  Edit Drop clicktime
clickid_6 INDEX 3753  Edit Drop clickid
linkid_4 INDEX 68  Edit Drop linkid
clickip_4 INDEX 3753  Edit Drop clickip
clicktime_4 INDEX 3753  Edit Drop clicktime
subscriberid_4 INDEX 3753  Edit Drop subscriberid
clickid_8 INDEX 3753  Edit Drop clickid
linkid_5 INDEX 68  Edit Drop linkid
clickip_5 INDEX 3753  Edit Drop clickip
statid_4 INDEX 56  Edit Drop statid
subscriberid_5 INDEX 3753  Edit Drop subscriberid
clicktime_5 INDEX 3753  Edit Drop clicktime
statid_5 INDEX 60  Edit Drop statid
clickid_10 INDEX 3753  Edit Drop clickid
linkid_6 INDEX 68  Edit Drop linkid
clickid_11 INDEX 3753  Edit Drop clickid
clicktime_6 INDEX 3753  Edit Drop clicktime
clickip_6 INDEX 3753  Edit Drop clickip
subscriberid_6 INDEX 3753  Edit Drop subscriberid
statid_6 INDEX 60  Edit Drop statid
linkid_7 INDEX 68  Edit Drop linkid
linkid_8 INDEX 68  Edit Drop linkid
Create an index on  columns  
 
Space usage: 
Type Usage
Data 278,528 Bytes
Index 5,360 KB
Total 5,632 KB
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Next Autoindex 3,918
Creation Apr 26, 2018 at 08:53 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: