Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_stats_autoresponders_recipients
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 739328 kB
Field
Type
Collation
Attributes
Null
Default
Extra
Action
statid
int(11)
No
0
autoresponderid
int(11)
Yes
0
send_status
char(1)
utf8_general_ci
Yes
NULL
recipient
int(11)
Yes
0
reason
varchar(20)
utf8_general_ci
Yes
NULL
sendtime
int(11)
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
statid
autoresponderid
send_status
recipient
reason
sendtime
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
0
statid
statid_2
UNIQUE
0
statid
statid_4
UNIQUE
0
statid
statid_6
UNIQUE
0
statid
statid_8
UNIQUE
0
statid
statid_9
UNIQUE
0
statid
statid_11
UNIQUE
0
statid
autoresponderid_2
UNIQUE
0
autoresponderid
send_status_2
UNIQUE
0
send_status
recipient_2
UNIQUE
0
recipient
reason_2
UNIQUE
0
reason
sendtime_2
UNIQUE
0
sendtime
reason_4
UNIQUE
0
reason
send_status_4
UNIQUE
0
send_status
recipient_4
UNIQUE
0
recipient
autoresponderid_4
UNIQUE
0
autoresponderid
sendtime_4
UNIQUE
0
sendtime
send_status_5
UNIQUE
0
send_status
sendtime_5
UNIQUE
0
sendtime
reason_5
UNIQUE
0
reason
recipient_6
UNIQUE
0
recipient
autoresponderid_5
UNIQUE
0
autoresponderid
send_status_7
UNIQUE
0
send_status
reason_7
UNIQUE
0
reason
recipient_8
UNIQUE
0
recipient
sendtime_7
UNIQUE
0
sendtime
sendtime_9
UNIQUE
0
sendtime
autoresponderid_8
UNIQUE
0
autoresponderid
recipient_10
UNIQUE
0
recipient
send_status_10
UNIQUE
0
send_status
autoresponderid_10
UNIQUE
0
autoresponderid
reason_10
UNIQUE
0
reason
send_status_11
UNIQUE
0
send_status
email_stats_autoresponders_recipients_stat_auto_recip
INDEX
0
statid
autoresponderid
recipient
statid
INDEX
0
statid
autoresponderid
INDEX
0
autoresponderid
send_status
INDEX
0
send_status
recipient
INDEX
0
recipient
reason
INDEX
0
reason
sendtime
INDEX
0
sendtime
autoresponderid_3
INDEX
0
autoresponderid
statid_3
INDEX
0
statid
recipient_3
INDEX
0
recipient
reason_3
INDEX
0
reason
send_status_3
INDEX
0
send_status
sendtime_3
INDEX
0
sendtime
send_status_6
INDEX
0
send_status
statid_5
INDEX
0
statid
recipient_5
INDEX
0
recipient
sendtime_6
INDEX
0
sendtime
autoresponderid_6
INDEX
0
autoresponderid
reason_6
INDEX
0
reason
statid_7
INDEX
0
statid
recipient_7
INDEX
0
recipient
send_status_8
INDEX
0
send_status
sendtime_8
INDEX
0
sendtime
reason_8
INDEX
0
reason
send_status_9
INDEX
0
send_status
recipient_9
INDEX
0
recipient
autoresponderid_7
INDEX
0
autoresponderid
sendtime_10
INDEX
0
sendtime
autoresponderid_9
INDEX
0
autoresponderid
reason_9
INDEX
0
reason
statid_10
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
Creation
Apr 15, 2018 at 11:25 PM
Run SQL query/queries on database puroparty
Fields:
SELECT * FROM `email_stats_autoresponders_recipients` WHERE 1
statid
autoresponderid
send_status
recipient
reason
sendtime
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