Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_queues
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 722944 kB
Field
Type
Collation
Attributes
Null
Default
Extra
Action
queueid
int(11)
Yes
0
queuetype
varchar(255)
utf8_general_ci
Yes
NULL
ownerid
int(11)
No
0
recipient
int(11)
Yes
0
processed
char(1)
utf8_general_ci
Yes
0
sent
char(1)
utf8_general_ci
Yes
0
processtime
datetime
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
queueid
queuetype
ownerid
recipient
processed
sent
processtime
Indexes:
Keyname
Type
Cardinality
Action
Field
email_queues_id_type_recip_idx
INDEX
102086
queueid
queuetype
recipient
email_queues_id_type_processed_idx
INDEX
48
queueid
queuetype
processed
email_queuetype_recipient_idx
INDEX
51043
queuetype
recipient
queueid
INDEX
88
queueid
queuetype
INDEX
4
queuetype
ownerid
INDEX
4
ownerid
recipient
INDEX
51043
recipient
processed
INDEX
30
processed
sent
INDEX
4
sent
processtime
INDEX
4
processtime
processed_2
INDEX
4
processed
recipient_2
INDEX
51043
recipient
queuetype_2
INDEX
4
queuetype
ownerid_2
INDEX
4
ownerid
processtime_2
INDEX
102086
processtime
queueid_2
INDEX
4
queueid
sent_2
INDEX
4
sent
processed_3
INDEX
4
processed
queuetype_3
INDEX
4
queuetype
sent_3
INDEX
4
sent
processtime_3
INDEX
4
processtime
ownerid_3
INDEX
4
ownerid
queueid_3
INDEX
4
queueid
recipient_3
INDEX
51043
recipient
queuetype_4
INDEX
4
queuetype
processtime_4
INDEX
4
processtime
ownerid_4
INDEX
4
ownerid
queueid_4
INDEX
4
queueid
sent_4
INDEX
4
sent
recipient_4
INDEX
51043
recipient
processed_4
INDEX
4
processed
ownerid_5
INDEX
4
ownerid
processed_5
INDEX
4
processed
queueid_5
INDEX
4
queueid
recipient_5
INDEX
51043
recipient
queuetype_5
INDEX
4
queuetype
processtime_5
INDEX
4
processtime
sent_5
INDEX
4
sent
queuetype_6
INDEX
4
queuetype
queueid_6
INDEX
60
queueid
processed_6
INDEX
4
processed
ownerid_6
INDEX
4
ownerid
sent_6
INDEX
4
sent
recipient_6
INDEX
51043
recipient
queueid_7
INDEX
4
queueid
queuetype_7
INDEX
4
queuetype
ownerid_7
INDEX
4
ownerid
recipient_7
INDEX
51043
recipient
processed_7
INDEX
4
processed
sent_7
INDEX
4
sent
processtime_6
INDEX
4
processtime
processtime_7
INDEX
4
processtime
queueid_8
INDEX
88
queueid
sent_8
INDEX
4
sent
queueid_9
INDEX
4
queueid
processtime_8
INDEX
102086
processtime
queuetype_8
INDEX
4
queuetype
sent_9
INDEX
4
sent
ownerid_8
INDEX
4
ownerid
recipient_8
INDEX
51043
recipient
ownerid_9
INDEX
4
ownerid
recipient_9
INDEX
51043
recipient
processed_8
INDEX
4
processed
processtime_9
INDEX
4
processtime
Create an index on
columns
Space usage:
Type
Usage
Data
7,696
KB
Index
178,176
KB
Total
185,872
KB
Row Statistic:
Statements
Value
Format
dynamic
Collation
utf8_general_ci
Creation
May 14, 2024 at 08:26 PM
Run SQL query/queries on database puroparty
Fields:
SELECT * FROM `email_queues` WHERE 1
queueid
queuetype
ownerid
recipient
processed
sent
processtime
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