Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_log_system_administrator
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 730112 kB
Field
Type
Collation
Attributes
Null
Default
Extra
Action
logid
int(11)
No
auto_increment
loguserid
int(11)
No
0
logip
varchar(30)
utf8_general_ci
No
logdate
int(11)
No
0
logtodo
varchar(100)
utf8_general_ci
No
logdata
text
utf8_general_ci
No
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
loguserid
logip
logdate
logtodo
logdata
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
0
logid
logid_2
UNIQUE
0
logid
loguserid_2
UNIQUE
0
loguserid
logip_2
UNIQUE
0
logip
logdate_2
UNIQUE
0
logdate
logtodo_2
UNIQUE
0
logtodo
logid_4
UNIQUE
0
logid
loguserid_4
UNIQUE
0
loguserid
logdate_4
UNIQUE
0
logdate
logtodo_4
UNIQUE
0
logtodo
logip_4
UNIQUE
0
logip
loguserid_5
UNIQUE
0
loguserid
logid_5
UNIQUE
0
logid
logdate_5
UNIQUE
0
logdate
logtodo_6
UNIQUE
0
logtodo
logip_6
UNIQUE
0
logip
loguserid_8
UNIQUE
0
loguserid
logid_8
UNIQUE
0
logid
logdate_8
UNIQUE
0
logdate
logtodo_8
UNIQUE
0
logtodo
logip_8
UNIQUE
0
logip
loguserid_9
UNIQUE
0
loguserid
logid_10
UNIQUE
0
logid
logtodo_9
UNIQUE
0
logtodo
loguserid_11
UNIQUE
0
loguserid
logip_9
UNIQUE
0
logip
logid_12
UNIQUE
0
logid
logdate_10
UNIQUE
0
logdate
logdate_12
UNIQUE
0
logdate
logid_14
UNIQUE
0
logid
loguserid_14
UNIQUE
0
loguserid
logid
INDEX
0
logid
loguserid
INDEX
0
loguserid
logip
INDEX
0
logip
logdate
INDEX
0
logdate
logtodo
INDEX
0
logtodo
logid_3
INDEX
0
logid
logdate_3
INDEX
0
logdate
loguserid_3
INDEX
0
loguserid
logip_3
INDEX
0
logip
logtodo_3
INDEX
0
logtodo
loguserid_6
INDEX
0
loguserid
logid_6
INDEX
0
logid
logip_5
INDEX
0
logip
logtodo_5
INDEX
0
logtodo
logdate_6
INDEX
0
logdate
logdate_7
INDEX
0
logdate
loguserid_7
INDEX
0
loguserid
logid_7
INDEX
0
logid
logtodo_7
INDEX
0
logtodo
logip_7
INDEX
0
logip
logid_9
INDEX
0
logid
logid_11
INDEX
0
logid
loguserid_10
INDEX
0
loguserid
loguserid_12
INDEX
0
loguserid
logdate_9
INDEX
0
logdate
logtodo_10
INDEX
0
logtodo
logip_10
INDEX
0
logip
logdate_11
INDEX
0
logdate
logtodo_11
INDEX
0
logtodo
logip_11
INDEX
0
logip
logid_13
INDEX
0
logid
loguserid_13
INDEX
0
loguserid
logip_12
INDEX
0
logip
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
1
Creation
Apr 25, 2024 at 04:54 PM
Run SQL query/queries on database puroparty
Fields:
ALTER TABLE `email_log_system_administrator` ADD UNIQUE(`logip`)
logid
loguserid
logip
logdate
logtodo
logdata
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