Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_jobs
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 737280 kB
Field
Type
Collation
Attributes
Null
Default
Extra
Action
jobid
int(11)
No
auto_increment
jobtype
varchar(255)
utf8_general_ci
Yes
NULL
jobstatus
char(1)
utf8_general_ci
Yes
NULL
jobtime
int(11)
Yes
0
jobdetails
text
utf8_general_ci
Yes
NULL
fkid
int(11)
Yes
0
lastupdatetime
int(11)
Yes
0
fktype
varchar(255)
utf8_general_ci
Yes
NULL
queueid
int(11)
Yes
0
ownerid
int(11)
Yes
0
approved
int(11)
Yes
0
authorisedtosend
int(11)
Yes
0
resendcount
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
jobid
jobtype
jobstatus
jobtime
jobdetails
fkid
lastupdatetime
fktype
queueid
ownerid
approved
authorisedtosend
resendcount
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
78
jobid
jobid_2
UNIQUE
78
jobid
jobid_4
UNIQUE
78
jobid
jobid_6
UNIQUE
78
jobid
jobid_8
UNIQUE
78
jobid
jobtime_2
UNIQUE
78
jobtime
lastupdatetime_2
UNIQUE
78
lastupdatetime
queueid_2
UNIQUE
78
queueid
lastupdatetime_3
UNIQUE
78
lastupdatetime
queueid_4
UNIQUE
78
queueid
jobtime_4
UNIQUE
78
jobtime
queueid_6
UNIQUE
78
queueid
lastupdatetime_6
UNIQUE
78
lastupdatetime
jobtime_6
UNIQUE
78
jobtime
queueid_7
UNIQUE
78
queueid
email_jobs_fkid_idx
INDEX
78
fkid
email_jobs_jobtime_idx
INDEX
78
jobtime
email_jobs_queue_idx
INDEX
78
queueid
email_jobs_owner_idx
INDEX
2
ownerid
jobid
INDEX
78
jobid
jobtype
INDEX
2
jobtype
jobstatus
INDEX
7
jobstatus
jobtime
INDEX
78
jobtime
fkid
INDEX
78
fkid
lastupdatetime
INDEX
78
lastupdatetime
fktype
INDEX
2
fktype
queueid
INDEX
78
queueid
ownerid
INDEX
2
ownerid
approved
INDEX
2
approved
authorisedtosend
INDEX
2
authorisedtosend
resendcount
INDEX
4
resendcount
jobstatus_2
INDEX
7
jobstatus
ownerid_2
INDEX
2
ownerid
resendcount_2
INDEX
4
resendcount
approved_2
INDEX
2
approved
queueid_3
INDEX
78
queueid
jobtime_3
INDEX
78
jobtime
fkid_2
INDEX
78
fkid
lastupdatetime_4
INDEX
78
lastupdatetime
jobtype_2
INDEX
2
jobtype
jobid_3
INDEX
78
jobid
authorisedtosend_2
INDEX
2
authorisedtosend
fktype_2
INDEX
2
fktype
jobid_5
INDEX
78
jobid
resendcount_3
INDEX
4
resendcount
fkid_3
INDEX
78
fkid
lastupdatetime_5
INDEX
78
lastupdatetime
queueid_5
INDEX
78
queueid
jobtime_5
INDEX
78
jobtime
ownerid_3
INDEX
2
ownerid
jobstatus_3
INDEX
7
jobstatus
approved_3
INDEX
2
approved
jobid_7
INDEX
78
jobid
authorisedtosend_3
INDEX
2
authorisedtosend
jobtype_3
INDEX
2
jobtype
fktype_3
INDEX
2
fktype
resendcount_4
INDEX
4
resendcount
fkid_4
INDEX
78
fkid
fktype_4
INDEX
2
fktype
authorisedtosend_4
INDEX
2
authorisedtosend
lastupdatetime_7
INDEX
78
lastupdatetime
jobtype_4
INDEX
2
jobtype
queueid_8
INDEX
78
queueid
fkid_5
INDEX
78
fkid
Create an index on
columns
Space usage:
Type
Usage
Data
98,304
Bytes
Index
1,008
KB
Total
1,104
KB
Row Statistic:
Statements
Value
Format
dynamic
Collation
utf8_general_ci
Next Autoindex
76
Creation
Mar 18, 2024 at 06:32 PM
Run SQL query/queries on database puroparty
Fields:
SELECT * FROM `email_jobs` WHERE 1
jobid
jobtype
jobstatus
jobtime
jobdetails
fkid
lastupdatetime
fktype
queueid
ownerid
approved
authorisedtosend
resendcount
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