Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_log_system_system
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 739328 kB
Field
Type
Collation
Attributes
Null
Default
Extra
Action
logid
int(11)
No
auto_increment
logtype
varchar(20)
utf8_general_ci
Yes
NULL
logmodule
varchar(100)
utf8_general_ci
No
logseverity
char(1)
utf8_general_ci
No
4
logsummary
varchar(250)
utf8_general_ci
No
logmsg
text
utf8_general_ci
No
logdate
int(11)
No
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
logid
logtype
logmodule
logseverity
logsummary
logmsg
logdate
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
5200
logid
logid_2
UNIQUE
5200
logid
logid_4
UNIQUE
5200
logid
logid_5
UNIQUE
5200
logid
logid_7
UNIQUE
5200
logid
logid_9
UNIQUE
5200
logid
logid_10
UNIQUE
5200
logid
logid_14
UNIQUE
5200
logid
logid
INDEX
5200
logid
logtype
INDEX
2
logtype
logmodule
INDEX
2
logmodule
logseverity
INDEX
2
logseverity
logsummary
INDEX
5200
logsummary
logdate
INDEX
5200
logdate
logdate_2
INDEX
5200
logdate
logid_3
INDEX
5200
logid
logtype_2
INDEX
2
logtype
logsummary_2
INDEX
5200
logsummary
logseverity_2
INDEX
2
logseverity
logmodule_2
INDEX
2
logmodule
logsummary_3
INDEX
5200
logsummary
logdate_3
INDEX
5200
logdate
logid_6
INDEX
5200
logid
logtype_3
INDEX
2
logtype
logmodule_3
INDEX
2
logmodule
logseverity_3
INDEX
2
logseverity
logseverity_4
INDEX
2
logseverity
logdate_4
INDEX
5200
logdate
logtype_4
INDEX
2
logtype
logsummary_4
INDEX
5200
logsummary
logid_8
INDEX
5200
logid
logmodule_4
INDEX
2
logmodule
logdate_5
INDEX
5200
logdate
logseverity_5
INDEX
2
logseverity
logmodule_5
INDEX
2
logmodule
logdate_6
INDEX
5200
logdate
logseverity_6
INDEX
2
logseverity
logid_11
INDEX
5200
logid
logsummary_5
INDEX
5200
logsummary
logid_12
INDEX
5200
logid
logtype_5
INDEX
2
logtype
logsummary_6
INDEX
5200
logsummary
logtype_6
INDEX
2
logtype
logmodule_6
INDEX
2
logmodule
logid_13
INDEX
5200
logid
logtype_7
INDEX
2
logtype
logmodule_7
INDEX
2
logmodule
logseverity_7
INDEX
2
logseverity
logsummary_7
INDEX
5200
logsummary
logdate_7
INDEX
5200
logdate
logseverity_8
INDEX
2
logseverity
logid_15
INDEX
5200
logid
logdate_8
INDEX
5200
logdate
logtype_8
INDEX
2
logtype
logsummary_8
INDEX
5200
logsummary
logmodule_8
INDEX
2
logmodule
logseverity_9
INDEX
2
logseverity
logid_16
INDEX
5200
logid
logdate_9
INDEX
5200
logdate
logtype_9
INDEX
2
logtype
logmodule_9
INDEX
2
logmodule
logsummary_9
INDEX
5200
logsummary
logsummary_10
INDEX
5200
logsummary
logmodule_10
INDEX
2
logmodule
Create an index on
columns
Space usage:
Type
Usage
Data
10,256
KB
Index
28,560
KB
Total
38,816
KB
Row Statistic:
Statements
Value
Format
dynamic
Collation
utf8_general_ci
Next Autoindex
8,626
Creation
May 24, 2018 at 03:34 PM
Run SQL query/queries on database puroparty
Fields:
ALTER TABLE `email_log_system_system` ADD UNIQUE(`logmodule`)
logid
logtype
logmodule
logseverity
logsummary
logmsg
logdate
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