Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: email_stats_autorespondersemail_stats_autoresponders
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0008 sec)
SQL-query: 
SELECT *
FROM `email_stats_autoresponders`
LIMIT 0 , 30
 [Edit] [Explain SQL] [Create PHP Code] [Refresh]


InnoDB free: 781312 kB

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    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
   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
   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
   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
   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
   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 Edit Drop statid
statid_2 UNIQUE Edit Drop statid
statid_3 UNIQUE Edit Drop statid
htmlrecipients_2 UNIQUE Edit Drop htmlrecipients
textrecipients_2 UNIQUE Edit Drop textrecipients
multipartrecipients_2 UNIQUE Edit Drop multipartrecipients
bouncecount_soft_2 UNIQUE Edit Drop bouncecount_soft
bouncecount_hard_2 UNIQUE Edit Drop bouncecount_hard
bouncecount_unknown_2 UNIQUE Edit Drop bouncecount_unknown
unsubscribecount_2 UNIQUE Edit Drop unsubscribecount
autoresponderid_2 UNIQUE Edit Drop autoresponderid
linkclicks_2 UNIQUE Edit Drop linkclicks
emailopens_2 UNIQUE Edit Drop emailopens
emailforwards_2 UNIQUE Edit Drop emailforwards
emailopens_unique_2 UNIQUE Edit Drop emailopens_unique
htmlopens_2 UNIQUE Edit Drop htmlopens
htmlopens_unique_2 UNIQUE Edit Drop htmlopens_unique
textopens_2 UNIQUE Edit Drop textopens
textopens_unique_2 UNIQUE Edit Drop textopens_unique
hiddenby_2 UNIQUE Edit Drop hiddenby
unsubscribecount_3 UNIQUE Edit Drop unsubscribecount
hiddenby_3 UNIQUE Edit Drop hiddenby
bouncecount_unknown_4 UNIQUE Edit Drop bouncecount_unknown
bouncecount_soft_3 UNIQUE Edit Drop bouncecount_soft
emailforwards_4 UNIQUE Edit Drop emailforwards
multipartrecipients_4 UNIQUE Edit Drop multipartrecipients
htmlrecipients_3 UNIQUE Edit Drop htmlrecipients
linkclicks_3 UNIQUE Edit Drop linkclicks
autoresponderid_3 UNIQUE Edit Drop autoresponderid
emailopens_3 UNIQUE Edit Drop emailopens
bouncecount_hard_3 UNIQUE Edit Drop bouncecount_hard
htmlopens_unique_3 UNIQUE Edit Drop htmlopens_unique
email_stats_autoresponders_statid_idx INDEX Edit Drop statid
email_stats_autoresponders_autoresponderid_idx INDEX Edit Drop autoresponderid
statid INDEX Edit Drop statid
htmlrecipients INDEX Edit Drop htmlrecipients
textrecipients INDEX Edit Drop textrecipients
multipartrecipients INDEX Edit Drop multipartrecipients
bouncecount_soft INDEX Edit Drop bouncecount_soft
bouncecount_hard INDEX Edit Drop bouncecount_hard
bouncecount_unknown INDEX Edit Drop bouncecount_unknown
unsubscribecount INDEX Edit Drop unsubscribecount
autoresponderid INDEX Edit Drop autoresponderid
linkclicks INDEX Edit Drop linkclicks
emailopens INDEX Edit Drop emailopens
emailforwards INDEX Edit Drop emailforwards
emailopens_unique INDEX Edit Drop emailopens_unique
htmlopens INDEX Edit Drop htmlopens
htmlopens_unique INDEX Edit Drop htmlopens_unique
textopens INDEX Edit Drop textopens
textopens_unique INDEX Edit Drop textopens_unique
hiddenby INDEX Edit Drop hiddenby
textopens_3 INDEX Edit Drop textopens
bouncecount_unknown_3 INDEX Edit Drop bouncecount_unknown
multipartrecipients_3 INDEX Edit Drop multipartrecipients
hiddenby_4 INDEX Edit Drop hiddenby
emailforwards_3 INDEX Edit Drop emailforwards
textopens_unique_3 INDEX Edit Drop textopens_unique
htmlrecipients_4 INDEX Edit Drop htmlrecipients
linkclicks_4 INDEX Edit Drop linkclicks
emailopens_4 INDEX Edit Drop emailopens
unsubscribecount_4 INDEX Edit Drop unsubscribecount
autoresponderid_4 INDEX Edit Drop autoresponderid
emailopens_unique_3 INDEX Edit Drop emailopens_unique
Create an index on  columns  
 
Space usage: 
Type Usage
Data 16,384 Bytes
Index 1,008 KB
Total 1,024 KB
 
Row Statistic: 
Statements Value
Format fixed
Collation utf8_general_ci
Creation Apr 08, 2018 at 03:12 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: