Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_list_subscribers
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 739328 kB
Field
Type
Collation
Attributes
Null
Default
Extra
Action
subscriberid
int(11)
No
auto_increment
listid
int(11)
No
0
emailaddress
varchar(200)
utf8_general_ci
Yes
NULL
domainname
varchar(100)
utf8_general_ci
Yes
NULL
format
char(1)
utf8_general_ci
Yes
NULL
confirmed
char(1)
utf8_general_ci
Yes
0
confirmcode
varchar(32)
utf8_general_ci
Yes
NULL
requestdate
int(11)
Yes
0
requestip
varchar(20)
utf8_general_ci
Yes
NULL
confirmdate
int(11)
Yes
0
confirmip
varchar(20)
utf8_general_ci
Yes
NULL
subscribedate
int(11)
Yes
0
bounced
int(11)
Yes
0
unsubscribed
int(11)
Yes
0
unsubscribeconfirmed
char(1)
utf8_general_ci
Yes
0
formid
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
subscriberid
listid
emailaddress
domainname
format
confirmed
confirmcode
requestdate
requestip
confirmdate
confirmip
subscribedate
bounced
unsubscribed
unsubscribeconfirmed
formid
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
36635
subscriberid
subscriberid_2
UNIQUE
36635
subscriberid
subscriberid_4
UNIQUE
36635
subscriberid
subscriberid_6
UNIQUE
36635
subscriberid
email_subscribers_email_list_idx
UNIQUE
36635
emailaddress
listid
confirmcode_2
UNIQUE
36635
confirmcode
confirmcode_3
UNIQUE
36635
confirmcode
confirmcode_5
UNIQUE
36635
confirmcode
email_list_subscribers_sub_list_idx
INDEX
36635
subscriberid
listid
email_subscribe_date_idx
INDEX
1465
subscribedate
subscriberid
INDEX
36635
subscriberid
listid
INDEX
50
listid
emailaddress
INDEX
36635
emailaddress
domainname
INDEX
7327
domainname
format
INDEX
2
format
confirmed
INDEX
2
confirmed
confirmcode
INDEX
36635
confirmcode
requestdate
INDEX
2818
requestdate
requestip
INDEX
2
requestip
confirmdate
INDEX
2818
confirmdate
confirmip
INDEX
2
confirmip
confirmip_2
INDEX
10
confirmip
subscribedate
INDEX
1928
subscribedate
bounced
INDEX
2
bounced
unsubscribed
INDEX
2
unsubscribed
unsubscribeconfirmed
INDEX
2
unsubscribeconfirmed
formid
INDEX
2
formid
emailaddress_2
INDEX
36635
emailaddress
requestip_2
INDEX
2
requestip
listid_2
INDEX
80
listid
confirmip_3
INDEX
10
confirmip
subscribedate_2
INDEX
2818
subscribedate
format_2
INDEX
2
format
confirmed_2
INDEX
2
confirmed
requestdate_2
INDEX
2818
requestdate
subscriberid_3
INDEX
36635
subscriberid
unsubscribed_2
INDEX
12
unsubscribed
unsubscribeconfirmed_2
INDEX
2
unsubscribeconfirmed
confirmdate_2
INDEX
1928
confirmdate
formid_2
INDEX
2
formid
domainname_2
INDEX
12211
domainname
confirmcode_4
INDEX
36635
confirmcode
bounced_2
INDEX
2
bounced
confirmip_4
INDEX
2
confirmip
requestip_3
INDEX
2
requestip
emailaddress_3
INDEX
36635
emailaddress
listid_3
INDEX
50
listid
subscribedate_3
INDEX
2155
subscribedate
confirmip_5
INDEX
10
confirmip
confirmed_3
INDEX
2
confirmed
unsubscribed_3
INDEX
3052
unsubscribed
subscriberid_5
INDEX
36635
subscriberid
unsubscribeconfirmed_3
INDEX
2
unsubscribeconfirmed
format_3
INDEX
2
format
requestdate_3
INDEX
3330
requestdate
confirmdate_3
INDEX
2035
confirmdate
formid_3
INDEX
2
formid
bounced_3
INDEX
2
bounced
domainname_3
INDEX
9158
domainname
confirmcode_6
INDEX
36635
confirmcode
subscribedate_4
INDEX
2616
subscribedate
confirmcode_7
INDEX
36635
confirmcode
bounced_4
INDEX
2
bounced
confirmed_4
INDEX
2
confirmed
Create an index on
columns
Space usage:
Type
Usage
Data
6,672
KB
Index
99,200
KB
Total
105,872
KB
Row Statistic:
Statements
Value
Format
dynamic
Collation
utf8_general_ci
Next Autoindex
36,582
Creation
Mar 19, 2018 at 05:47 AM
Run SQL query/queries on database puroparty
Fields:
SELECT * FROM `email_list_subscribers` WHERE 1
subscriberid
listid
emailaddress
domainname
format
confirmed
confirmcode
requestdate
requestip
confirmdate
confirmip
subscribedate
bounced
unsubscribed
unsubscribeconfirmed
formid
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