Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_list_subscriber_bounces
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 726016 kB
Field
Type
Collation
Attributes
Null
Default
Extra
Action
bounceid
int(11)
No
auto_increment
subscriberid
int(11)
Yes
0
statid
int(11)
Yes
0
listid
int(11)
Yes
0
bouncetime
int(11)
Yes
0
bouncetype
varchar(255)
utf8_general_ci
Yes
NULL
bouncerule
varchar(255)
utf8_general_ci
Yes
NULL
bouncemessage
longtext
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
bounceid
subscriberid
statid
listid
bouncetime
bouncetype
bouncerule
bouncemessage
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
0
bounceid
bounceid_2
UNIQUE
0
bounceid
bounceid_4
UNIQUE
0
bounceid
bounceid_6
UNIQUE
0
bounceid
bounceid_9
UNIQUE
0
bounceid
subscriberid_2
UNIQUE
0
subscriberid
statid_2
UNIQUE
0
statid
listid_2
UNIQUE
0
listid
bouncetime_2
UNIQUE
0
bouncetime
bouncetype_2
UNIQUE
0
bouncetype
bouncerule_2
UNIQUE
0
bouncerule
bouncetype_3
UNIQUE
0
bouncetype
subscriberid_4
UNIQUE
0
subscriberid
bouncerule_3
UNIQUE
0
bouncerule
statid_3
UNIQUE
0
statid
listid_4
UNIQUE
0
listid
bouncetime_3
UNIQUE
0
bouncetime
subscriberid_5
UNIQUE
0
subscriberid
bouncetype_5
UNIQUE
0
bouncetype
statid_5
UNIQUE
0
statid
bouncerule_5
UNIQUE
0
bouncerule
listid_6
UNIQUE
0
listid
bouncetime_6
UNIQUE
0
bouncetime
statid_7
UNIQUE
0
statid
bouncetype_7
UNIQUE
0
bouncetype
bouncetime_7
UNIQUE
0
bouncetime
subscriberid_8
UNIQUE
0
subscriberid
statid_8
UNIQUE
0
statid
bouncetype_8
UNIQUE
0
bouncetype
bouncerule_8
UNIQUE
0
bouncerule
listid_7
UNIQUE
0
listid
subscriberid_10
UNIQUE
0
subscriberid
email_list_subscriber_bounces_statid_idx
INDEX
0
statid
email_list_subscriber_bounces_listid_idx
INDEX
0
listid
email_list_subscriber_bounces_subscriberid_idx
INDEX
0
subscriberid
bounceid
INDEX
0
bounceid
subscriberid
INDEX
0
subscriberid
statid
INDEX
0
statid
listid
INDEX
0
listid
bouncetime
INDEX
0
bouncetime
bouncetype
INDEX
0
bouncetype
bouncerule
INDEX
0
bouncerule
subscriberid_3
INDEX
0
subscriberid
bouncerule_4
INDEX
0
bouncerule
bounceid_3
INDEX
0
bounceid
listid_3
INDEX
0
listid
bouncetype_4
INDEX
0
bouncetype
bouncetime_4
INDEX
0
bouncetime
statid_4
INDEX
0
statid
subscriberid_6
INDEX
0
subscriberid
bounceid_5
INDEX
0
bounceid
listid_5
INDEX
0
listid
bouncetype_6
INDEX
0
bouncetype
bouncerule_6
INDEX
0
bouncerule
bouncetime_5
INDEX
0
bouncetime
statid_6
INDEX
0
statid
subscriberid_7
INDEX
0
subscriberid
bounceid_7
INDEX
0
bounceid
bouncetime_8
INDEX
0
bouncetime
bounceid_8
INDEX
0
bounceid
bouncerule_7
INDEX
0
bouncerule
subscriberid_9
INDEX
0
subscriberid
bouncetype_9
INDEX
0
bouncetype
statid_9
INDEX
0
statid
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
dynamic
Collation
utf8_general_ci
Next Autoindex
1
Creation
May 20, 2024 at 06:30 PM
Run SQL query/queries on database puroparty
Fields:
ALTER TABLE `email_list_subscriber_bounces` ADD UNIQUE(`bouncetype`)
bounceid
subscriberid
statid
listid
bouncetime
bouncetype
bouncerule
bouncemessage
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