Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_list_subscribers_unsubscribe
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 729088 kB
Field
Type
Collation
Attributes
Null
Default
Extra
Action
subscriberid
int(11)
No
0
unsubscribetime
int(11)
No
0
unsubscribeip
varchar(20)
utf8_general_ci
Yes
NULL
unsubscriberequesttime
int(11)
Yes
0
unsubscriberequestip
varchar(20)
utf8_general_ci
Yes
NULL
listid
int(11)
No
0
statid
int(11)
Yes
0
unsubscribearea
varchar(20)
utf8_general_ci
Yes
NULL
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
unsubscribetime
unsubscribeip
unsubscriberequesttime
unsubscriberequestip
listid
statid
unsubscribearea
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
353
subscriberid
subscriberid_2
UNIQUE
353
subscriberid
unsubscribetime_2
UNIQUE
353
unsubscribetime
unsubscribetime_4
UNIQUE
353
unsubscribetime
subscriberid_3
UNIQUE
353
subscriberid
subscriberid_5
UNIQUE
353
subscriberid
unsubscribetime_6
UNIQUE
353
unsubscribetime
subscriberid_8
UNIQUE
353
subscriberid
unsubscribetime_8
UNIQUE
353
unsubscribetime
unsubscribetime_9
UNIQUE
353
unsubscribetime
subscriberid_9
UNIQUE
353
subscriberid
subscriberid_12
UNIQUE
353
subscriberid
unsubscribetime_12
UNIQUE
353
unsubscribetime
email_list_unsubscribe_sub_list_idx
INDEX
353
subscriberid
listid
email_list_subscribers_unsubscribe_statid_idx
INDEX
39
statid
subscriberid
INDEX
353
subscriberid
unsubscribetime
INDEX
353
unsubscribetime
unsubscribeip
INDEX
353
unsubscribeip
unsubscriberequesttime
INDEX
2
unsubscriberequesttime
unsubscriberequestip
INDEX
2
unsubscriberequestip
listid
INDEX
14
listid
statid
INDEX
39
statid
unsubscribearea
INDEX
4
unsubscribearea
unsubscriberequestip_2
INDEX
2
unsubscriberequestip
unsubscriberequesttime_2
INDEX
2
unsubscriberequesttime
unsubscribetime_3
INDEX
353
unsubscribetime
statid_2
INDEX
39
statid
subscriberid_4
INDEX
353
subscriberid
listid_2
INDEX
14
listid
unsubscribeip_2
INDEX
353
unsubscribeip
unsubscribearea_2
INDEX
4
unsubscribearea
statid_3
INDEX
39
statid
unsubscribearea_3
INDEX
4
unsubscribearea
unsubscribeip_3
INDEX
353
unsubscribeip
unsubscriberequestip_3
INDEX
2
unsubscriberequestip
subscriberid_6
INDEX
353
subscriberid
unsubscriberequesttime_3
INDEX
2
unsubscriberequesttime
listid_3
INDEX
14
listid
unsubscribetime_5
INDEX
353
unsubscribetime
unsubscribeip_4
INDEX
353
unsubscribeip
unsubscribearea_4
INDEX
4
unsubscribearea
statid_4
INDEX
39
statid
subscriberid_7
INDEX
353
subscriberid
unsubscriberequestip_4
INDEX
2
unsubscriberequestip
unsubscriberequesttime_4
INDEX
2
unsubscriberequesttime
unsubscriberequestip_5
INDEX
2
unsubscriberequestip
listid_4
INDEX
14
listid
unsubscribearea_5
INDEX
4
unsubscribearea
unsubscribetime_7
INDEX
353
unsubscribetime
statid_5
INDEX
39
statid
unsubscribeip_5
INDEX
353
unsubscribeip
unsubscriberequesttime_5
INDEX
2
unsubscriberequesttime
listid_5
INDEX
14
listid
unsubscribetime_10
INDEX
353
unsubscribetime
subscriberid_10
INDEX
353
subscriberid
unsubscriberequesttime_6
INDEX
2
unsubscriberequesttime
unsubscribeip_6
INDEX
353
unsubscribeip
subscriberid_11
INDEX
353
subscriberid
unsubscribetime_11
INDEX
353
unsubscribetime
unsubscribeip_7
INDEX
353
unsubscribeip
unsubscriberequesttime_7
INDEX
2
unsubscriberequesttime
unsubscriberequestip_6
INDEX
2
unsubscriberequestip
listid_6
INDEX
14
listid
statid_6
INDEX
39
statid
Create an index on
columns
Space usage:
Type
Usage
Data
49,152
Bytes
Index
1,008
KB
Total
1,056
KB
Row Statistic:
Statements
Value
Format
dynamic
Collation
utf8_general_ci
Creation
Jun 25, 2024 at 01:09 AM
Run SQL query/queries on database puroparty
Fields:
SELECT * FROM `email_list_subscribers_unsubscribe` WHERE 1
subscriberid
unsubscribetime
unsubscribeip
unsubscriberequesttime
unsubscriberequestip
listid
statid
unsubscribearea
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