Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_stats_emailopens
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 729088 kB
Field
Type
Collation
Attributes
Null
Default
Extra
Action
openid
int(11)
No
auto_increment
subscriberid
int(11)
Yes
0
statid
int(11)
Yes
0
opentime
int(11)
Yes
0
openip
varchar(20)
utf8_general_ci
Yes
NULL
fromlink
char(1)
utf8_general_ci
Yes
0
opentype
char(1)
utf8_general_ci
Yes
u
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
openid
subscriberid
statid
opentime
openip
fromlink
opentype
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
27262
openid
openid_2
UNIQUE
27262
openid
openid_4
UNIQUE
27262
openid
openid_5
UNIQUE
27262
openid
openid_9
UNIQUE
27262
openid
openid_10
UNIQUE
27262
openid
openid_11
UNIQUE
27262
openid
openid_13
UNIQUE
27262
openid
openid_15
UNIQUE
27262
openid
email_stats_emailopens_subscriberid_idx
INDEX
9087
subscriberid
email_stats_emailopens_statid_idx
INDEX
89
statid
email_open_statid_subscriberid
INDEX
27262
subscriberid
statid
openid
INDEX
27262
openid
subscriberid
INDEX
13631
subscriberid
statid
INDEX
186
statid
opentime
INDEX
27262
opentime
openip
INDEX
27262
openip
fromlink
INDEX
1
fromlink
opentype
INDEX
1
opentype
openip_2
INDEX
27262
openip
opentype_2
INDEX
1
opentype
statid_2
INDEX
167
statid
openid_3
INDEX
27262
openid
opentime_2
INDEX
27262
opentime
fromlink_2
INDEX
1
fromlink
subscriberid_2
INDEX
13631
subscriberid
statid_3
INDEX
186
statid
fromlink_3
INDEX
1
fromlink
openip_3
INDEX
27262
openip
opentype_3
INDEX
1
opentype
openid_6
INDEX
27262
openid
opentime_3
INDEX
27262
opentime
subscriberid_3
INDEX
9087
subscriberid
openid_7
INDEX
27262
openid
opentype_4
INDEX
1
opentype
opentype_5
INDEX
1
opentype
openid_8
INDEX
27262
openid
subscriberid_4
INDEX
9087
subscriberid
openip_4
INDEX
27262
openip
statid_4
INDEX
225
statid
fromlink_4
INDEX
7
fromlink
fromlink_5
INDEX
1
fromlink
opentime_4
INDEX
27262
opentime
openip_5
INDEX
13631
openip
statid_5
INDEX
225
statid
openip_6
INDEX
27262
openip
fromlink_6
INDEX
7
fromlink
statid_6
INDEX
108
statid
opentime_5
INDEX
27262
opentime
openid_12
INDEX
27262
openid
subscriberid_5
INDEX
13631
subscriberid
statid_7
INDEX
186
statid
opentime_6
INDEX
27262
opentime
openip_7
INDEX
27262
openip
fromlink_7
INDEX
7
fromlink
opentype_6
INDEX
1
opentype
subscriberid_6
INDEX
13631
subscriberid
opentime_7
INDEX
27262
opentime
subscriberid_7
INDEX
9087
subscriberid
subscriberid_8
INDEX
13631
subscriberid
openid_14
INDEX
27262
openid
statid_8
INDEX
186
statid
openip_8
INDEX
27262
openip
opentime_8
INDEX
27262
opentime
Create an index on
columns
Space usage:
Type
Usage
Data
2,576
KB
Index
56,720
KB
Total
59,296
KB
Row Statistic:
Statements
Value
Format
dynamic
Collation
utf8_general_ci
Next Autoindex
27,389
Creation
Jun 13, 2024 at 10:00 PM
Run SQL query/queries on database puroparty
Fields:
SELECT * FROM `email_stats_emailopens` WHERE 1
openid
subscriberid
statid
opentime
openip
fromlink
opentype
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