Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_stats_autoresponders
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 739328 kB
Field
Type
Collation
Attributes
Null
Default
Extra
Action
statid
int(11)
No
0
htmlrecipients
int(11)
Yes
0
textrecipients
int(11)
Yes
0
multipartrecipients
int(11)
Yes
0
bouncecount_soft
int(11)
Yes
0
bouncecount_hard
int(11)
Yes
0
bouncecount_unknown
int(11)
Yes
0
unsubscribecount
int(11)
Yes
0
autoresponderid
int(11)
Yes
0
linkclicks
int(11)
Yes
0
emailopens
int(11)
Yes
0
emailforwards
int(11)
Yes
0
emailopens_unique
int(11)
Yes
0
htmlopens
int(11)
Yes
0
htmlopens_unique
int(11)
Yes
0
textopens
int(11)
Yes
0
textopens_unique
int(11)
Yes
0
hiddenby
int(11)
Yes
0
Check All
/
Uncheck All
With selected:
Print view
Relation view
Propose table structure
Add new field:
At End of Table
At Beginning of Table
After
statid
htmlrecipients
textrecipients
multipartrecipients
bouncecount_soft
bouncecount_hard
bouncecount_unknown
unsubscribecount
autoresponderid
linkclicks
emailopens
emailforwards
emailopens_unique
htmlopens
htmlopens_unique
textopens
textopens_unique
hiddenby
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
0
statid
statid_2
UNIQUE
0
statid
statid_3
UNIQUE
0
statid
htmlrecipients_2
UNIQUE
0
htmlrecipients
textrecipients_2
UNIQUE
0
textrecipients
multipartrecipients_2
UNIQUE
0
multipartrecipients
bouncecount_soft_2
UNIQUE
0
bouncecount_soft
bouncecount_hard_2
UNIQUE
0
bouncecount_hard
bouncecount_unknown_2
UNIQUE
0
bouncecount_unknown
unsubscribecount_2
UNIQUE
0
unsubscribecount
autoresponderid_2
UNIQUE
0
autoresponderid
linkclicks_2
UNIQUE
0
linkclicks
emailopens_2
UNIQUE
0
emailopens
emailforwards_2
UNIQUE
0
emailforwards
emailopens_unique_2
UNIQUE
0
emailopens_unique
htmlopens_2
UNIQUE
0
htmlopens
htmlopens_unique_2
UNIQUE
0
htmlopens_unique
textopens_2
UNIQUE
0
textopens
textopens_unique_2
UNIQUE
0
textopens_unique
hiddenby_2
UNIQUE
0
hiddenby
unsubscribecount_3
UNIQUE
0
unsubscribecount
hiddenby_3
UNIQUE
0
hiddenby
bouncecount_unknown_4
UNIQUE
0
bouncecount_unknown
bouncecount_soft_3
UNIQUE
0
bouncecount_soft
emailforwards_4
UNIQUE
0
emailforwards
multipartrecipients_4
UNIQUE
0
multipartrecipients
htmlrecipients_3
UNIQUE
0
htmlrecipients
linkclicks_3
UNIQUE
0
linkclicks
autoresponderid_3
UNIQUE
0
autoresponderid
emailopens_3
UNIQUE
0
emailopens
bouncecount_hard_3
UNIQUE
0
bouncecount_hard
htmlopens_unique_3
UNIQUE
0
htmlopens_unique
email_stats_autoresponders_statid_idx
INDEX
0
statid
email_stats_autoresponders_autoresponderid_idx
INDEX
0
autoresponderid
statid
INDEX
0
statid
htmlrecipients
INDEX
0
htmlrecipients
textrecipients
INDEX
0
textrecipients
multipartrecipients
INDEX
0
multipartrecipients
bouncecount_soft
INDEX
0
bouncecount_soft
bouncecount_hard
INDEX
0
bouncecount_hard
bouncecount_unknown
INDEX
0
bouncecount_unknown
unsubscribecount
INDEX
0
unsubscribecount
autoresponderid
INDEX
0
autoresponderid
linkclicks
INDEX
0
linkclicks
emailopens
INDEX
0
emailopens
emailforwards
INDEX
0
emailforwards
emailopens_unique
INDEX
0
emailopens_unique
htmlopens
INDEX
0
htmlopens
htmlopens_unique
INDEX
0
htmlopens_unique
textopens
INDEX
0
textopens
textopens_unique
INDEX
0
textopens_unique
hiddenby
INDEX
0
hiddenby
textopens_3
INDEX
0
textopens
bouncecount_unknown_3
INDEX
0
bouncecount_unknown
multipartrecipients_3
INDEX
0
multipartrecipients
hiddenby_4
INDEX
0
hiddenby
emailforwards_3
INDEX
0
emailforwards
textopens_unique_3
INDEX
0
textopens_unique
htmlrecipients_4
INDEX
0
htmlrecipients
linkclicks_4
INDEX
0
linkclicks
emailopens_4
INDEX
0
emailopens
unsubscribecount_4
INDEX
0
unsubscribecount
autoresponderid_4
INDEX
0
autoresponderid
emailopens_unique_3
INDEX
0
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
Mar 20, 2024 at 11:34 AM
Run SQL query/queries on database puroparty
Fields:
ALTER TABLE `email_stats_autoresponders` ADD INDEX(`multipartrecipients`)
statid
htmlrecipients
textrecipients
multipartrecipients
bouncecount_soft
bouncecount_hard
bouncecount_unknown
unsubscribecount
autoresponderid
linkclicks
emailopens
emailforwards
emailopens_unique
htmlopens
htmlopens_unique
textopens
textopens_unique
hiddenby
Show this query here again
Or
Location of the textfile:
Location of the textfile:
(Max: 2,048KB)
Compression:
Autodetect
None
"gzipped"
"bzipped"
Character set of the file:
armscii8
ascii
big5
binary
cp1250
cp1251
cp1256
cp1257
cp850
cp852
cp866
cp932
dec8
euckr
gb2312
gbk
geostd8
greek
hebrew
hp8
keybcs2
koi8r
koi8u
latin1
latin2
latin5
latin7
macce
macroman
sjis
swe7
tis620
ucs2
ujis
utf8
Insert data from a textfile into table