Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_lists
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 729088 kB
Field
Type
Collation
Attributes
Null
Default
Extra
Action
listid
int(11)
No
auto_increment
name
varchar(255)
utf8_general_ci
Yes
NULL
ownername
varchar(255)
utf8_general_ci
Yes
NULL
owneremail
varchar(100)
utf8_general_ci
Yes
NULL
bounceemail
varchar(100)
utf8_general_ci
Yes
NULL
replytoemail
varchar(100)
utf8_general_ci
Yes
NULL
bounceserver
varchar(100)
utf8_general_ci
Yes
NULL
bounceusername
varchar(100)
utf8_general_ci
Yes
NULL
bouncepassword
varchar(100)
utf8_general_ci
Yes
NULL
extramailsettings
varchar(100)
utf8_general_ci
Yes
NULL
companyname
varchar(255)
utf8_general_ci
Yes
NULL
companyaddress
varchar(255)
utf8_general_ci
Yes
NULL
companyphone
varchar(20)
utf8_general_ci
Yes
NULL
format
char(1)
utf8_general_ci
Yes
NULL
notifyowner
char(1)
utf8_general_ci
Yes
0
imapaccount
char(1)
utf8_general_ci
Yes
0
createdate
int(11)
Yes
0
subscribecount
int(11)
Yes
0
unsubscribecount
int(11)
Yes
0
bouncecount
int(11)
Yes
0
processbounce
char(1)
utf8_general_ci
Yes
0
agreedelete
char(1)
utf8_general_ci
Yes
0
visiblefields
text
utf8_general_ci
No
ownerid
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
listid
name
ownername
owneremail
bounceemail
replytoemail
bounceserver
bounceusername
bouncepassword
extramailsettings
companyname
companyaddress
companyphone
format
notifyowner
imapaccount
createdate
subscribecount
unsubscribecount
bouncecount
processbounce
agreedelete
visiblefields
ownerid
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
16
listid
listid_2
UNIQUE
16
listid
listid_4
UNIQUE
16
listid
listid_6
UNIQUE
16
listid
name_2
UNIQUE
16
name
createdate_2
UNIQUE
16
createdate
name_3
UNIQUE
16
name
createdate_3
UNIQUE
16
createdate
createdate_5
UNIQUE
16
createdate
email_lists_owner_idx
INDEX
2
ownerid
listid
INDEX
16
listid
name
INDEX
16
name
ownername
INDEX
8
ownername
owneremail
INDEX
4
owneremail
bounceemail
INDEX
4
bounceemail
replytoemail
INDEX
4
replytoemail
bounceserver
INDEX
4
bounceserver
bounceusername
INDEX
4
bounceusername
bouncepassword
INDEX
4
bouncepassword
extramailsettings
INDEX
2
extramailsettings
companyname
INDEX
4
companyname
companyaddress
INDEX
8
companyaddress
companyphone
INDEX
4
companyphone
format
INDEX
2
format
notifyowner
INDEX
4
notifyowner
imapaccount
INDEX
2
imapaccount
createdate
INDEX
16
createdate
subscribecount
INDEX
16
subscribecount
unsubscribecount
INDEX
16
unsubscribecount
bouncecount
INDEX
2
bouncecount
processbounce
INDEX
4
processbounce
agreedelete
INDEX
4
agreedelete
ownerid
INDEX
2
ownerid
replytoemail_2
INDEX
4
replytoemail
bounceemail_2
INDEX
4
bounceemail
companyname_2
INDEX
4
companyname
extramailsettings_2
INDEX
2
extramailsettings
processbounce_2
INDEX
4
processbounce
unsubscribecount_2
INDEX
16
unsubscribecount
bouncecount_2
INDEX
2
bouncecount
bouncepassword_2
INDEX
4
bouncepassword
ownerid_2
INDEX
2
ownerid
bounceusername_2
INDEX
4
bounceusername
companyaddress_2
INDEX
8
companyaddress
name_4
INDEX
16
name
listid_3
INDEX
16
listid
agreedelete_2
INDEX
4
agreedelete
ownername_2
INDEX
8
ownername
bounceserver_2
INDEX
4
bounceserver
owneremail_2
INDEX
4
owneremail
subscribecount_2
INDEX
16
subscribecount
format_2
INDEX
2
format
notifyowner_2
INDEX
4
notifyowner
createdate_4
INDEX
16
createdate
companyphone_2
INDEX
4
companyphone
imapaccount_2
INDEX
2
imapaccount
bounceserver_3
INDEX
4
bounceserver
listid_5
INDEX
16
listid
replytoemail_3
INDEX
4
replytoemail
extramailsettings_3
INDEX
2
extramailsettings
bounceusername_3
INDEX
4
bounceusername
name_5
INDEX
16
name
ownerid_3
INDEX
2
ownerid
bounceemail_3
INDEX
4
bounceemail
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
19
Creation
May 16, 2024 at 12:51 AM
Run SQL query/queries on database puroparty
Fields:
ALTER TABLE `email_lists` ADD INDEX(`bounceemail`)
listid
name
ownername
owneremail
bounceemail
replytoemail
bounceserver
bounceusername
bouncepassword
extramailsettings
companyname
companyaddress
companyphone
format
notifyowner
imapaccount
createdate
subscribecount
unsubscribecount
bouncecount
processbounce
agreedelete
visiblefields
ownerid
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