Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_stats_newsletters
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 743424 kB
Field
Type
Collation
Attributes
Null
Default
Extra
Action
statid
int(11)
No
0
queueid
int(11)
Yes
0
jobid
int(11)
Yes
0
starttime
int(11)
Yes
0
finishtime
int(11)
Yes
0
htmlrecipients
int(11)
Yes
0
textrecipients
int(11)
Yes
0
multipartrecipients
int(11)
Yes
0
trackopens
char(1)
utf8_general_ci
Yes
0
tracklinks
char(1)
utf8_general_ci
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
newsletterid
int(11)
Yes
0
sendfromname
varchar(200)
utf8_general_ci
Yes
NULL
sendfromemail
varchar(200)
utf8_general_ci
Yes
NULL
bounceemail
varchar(200)
utf8_general_ci
Yes
NULL
replytoemail
varchar(200)
utf8_general_ci
Yes
NULL
charset
varchar(200)
utf8_general_ci
Yes
NULL
sendinformation
mediumtext
utf8_general_ci
Yes
NULL
sendsize
int(11)
Yes
0
sentby
int(11)
Yes
0
notifyowner
char(1)
utf8_general_ci
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
sendtestmode
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
queueid
jobid
starttime
finishtime
htmlrecipients
textrecipients
multipartrecipients
trackopens
tracklinks
bouncecount_soft
bouncecount_hard
bouncecount_unknown
unsubscribecount
newsletterid
sendfromname
sendfromemail
bounceemail
replytoemail
charset
sendinformation
sendsize
sentby
notifyowner
linkclicks
emailopens
emailforwards
emailopens_unique
htmlopens
htmlopens_unique
textopens
textopens_unique
hiddenby
sendtestmode
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
13
statid
statid_2
UNIQUE
13
statid
queueid_2
UNIQUE
13
queueid
jobid_2
UNIQUE
13
jobid
starttime_2
UNIQUE
13
starttime
queueid_3
UNIQUE
13
queueid
starttime_3
UNIQUE
13
starttime
jobid_4
UNIQUE
13
jobid
email_stats_newsletters_queue_idx
INDEX
13
queueid
email_stats_newsletters_sentby_idx
INDEX
2
sentby
statid
INDEX
13
statid
queueid
INDEX
13
queueid
jobid
INDEX
13
jobid
starttime
INDEX
13
starttime
finishtime
INDEX
13
finishtime
htmlrecipients
INDEX
2
htmlrecipients
textrecipients
INDEX
2
textrecipients
multipartrecipients
INDEX
13
multipartrecipients
trackopens
INDEX
2
trackopens
tracklinks
INDEX
4
tracklinks
bouncecount_soft
INDEX
2
bouncecount_soft
bouncecount_hard
INDEX
2
bouncecount_hard
bouncecount_unknown
INDEX
2
bouncecount_unknown
unsubscribecount
INDEX
13
unsubscribecount
newsletterid
INDEX
13
newsletterid
sendfromname
INDEX
13
sendfromname
sendfromemail
INDEX
6
sendfromemail
bounceemail
INDEX
6
bounceemail
replytoemail
INDEX
6
replytoemail
charset
INDEX
2
charset
sendsize
INDEX
13
sendsize
sentby
INDEX
2
sentby
notifyowner
INDEX
2
notifyowner
linkclicks
INDEX
13
linkclicks
emailopens
INDEX
13
emailopens
emailforwards
INDEX
2
emailforwards
emailopens_unique
INDEX
13
emailopens_unique
htmlopens
INDEX
13
htmlopens
htmlopens_unique
INDEX
13
htmlopens_unique
textopens
INDEX
2
textopens
textopens_unique
INDEX
2
textopens_unique
hiddenby
INDEX
4
hiddenby
sendtestmode
INDEX
2
sendtestmode
bouncecount_unknown_2
INDEX
2
bouncecount_unknown
multipartrecipients_2
INDEX
13
multipartrecipients
textopens_2
INDEX
2
textopens
sendfromname_2
INDEX
13
sendfromname
sendtestmode_2
INDEX
2
sendtestmode
emailopens_2
INDEX
13
emailopens
charset_2
INDEX
2
charset
trackopens_2
INDEX
2
trackopens
statid_3
INDEX
13
statid
htmlrecipients_2
INDEX
2
htmlrecipients
jobid_3
INDEX
13
jobid
emailopens_unique_2
INDEX
13
emailopens_unique
finishtime_2
INDEX
13
finishtime
tracklinks_2
INDEX
4
tracklinks
notifyowner_2
INDEX
2
notifyowner
bounceemail_2
INDEX
6
bounceemail
starttime_4
INDEX
13
starttime
queueid_4
INDEX
13
queueid
unsubscribecount_2
INDEX
13
unsubscribecount
bouncecount_soft_2
INDEX
2
bouncecount_soft
sentby_2
INDEX
2
sentby
Create an index on
columns
Space usage:
Type
Usage
Data
65,536
Bytes
Index
1,008
KB
Total
1,072
KB
Row Statistic:
Statements
Value
Format
dynamic
Collation
utf8_general_ci
Creation
Mar 28, 2024 at 07:53 AM
Run SQL query/queries on database puroparty
Fields:
ALTER TABLE `email_stats_newsletters` ADD UNIQUE(`replytoemail`)
statid
queueid
jobid
starttime
finishtime
htmlrecipients
textrecipients
multipartrecipients
trackopens
tracklinks
bouncecount_soft
bouncecount_hard
bouncecount_unknown
unsubscribecount
newsletterid
sendfromname
sendfromemail
bounceemail
replytoemail
charset
sendinformation
sendsize
sentby
notifyowner
linkclicks
emailopens
emailforwards
emailopens_unique
htmlopens
htmlopens_unique
textopens
textopens_unique
hiddenby
sendtestmode
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