Server:
mysql.puroparty.com
Database:
puroparty
Table:
photopost_admlog
An index has been added on id (Query took 0.0101 sec)
SQL-query:
ALTER
TABLE
`photopost_admlog`
ADD
UNIQUE
(
`id`
)
[
Edit
] [
Create PHP Code
]
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Field
Type
Collation
Attributes
Null
Default
Extra
Action
id
int(10)
No
auto_increment
adminuser
varchar(50)
latin1_swedish_ci
No
description
varchar(255)
latin1_swedish_ci
No
datestamp
int(20)
No
0
ip
varchar(35)
latin1_swedish_ci
No
Check All
/
Uncheck All
With selected:
Print view
Propose table structure
Add new field:
At End of Table
At Beginning of Table
After
id
adminuser
description
datestamp
ip
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
4
id
id_2
UNIQUE
4
id
datestamp_2
UNIQUE
4
datestamp
datestamp_3
UNIQUE
4
datestamp
id_4
UNIQUE
4
id
datestamp_5
UNIQUE
4
datestamp
id_6
UNIQUE
4
id
datestamp_7
UNIQUE
4
datestamp
id_8
UNIQUE
4
id
datestamp_9
UNIQUE
4
datestamp
id_11
UNIQUE
4
id
datestamp_11
UNIQUE
4
datestamp
id_12
UNIQUE
4
id
id
INDEX
None
id
adminuser
INDEX
None
adminuser
description
INDEX
None
description
datestamp
INDEX
None
datestamp
ip
INDEX
None
ip
description_3
INDEX
None
description
adminuser_3
INDEX
None
adminuser
id_3
INDEX
None
id
ip_4
INDEX
None
ip
datestamp_4
INDEX
None
datestamp
adminuser_5
INDEX
None
adminuser
id_5
INDEX
None
id
ip_6
INDEX
None
ip
datestamp_6
INDEX
None
datestamp
description_6
INDEX
None
description
description_7
INDEX
None
description
id_7
INDEX
None
id
adminuser_8
INDEX
None
adminuser
ip_8
INDEX
None
ip
datestamp_8
INDEX
None
datestamp
id_9
INDEX
None
id
description_9
INDEX
None
description
adminuser_10
INDEX
None
adminuser
id_10
INDEX
None
id
adminuser_11
INDEX
None
adminuser
description_10
INDEX
None
description
datestamp_10
INDEX
None
datestamp
ip_10
INDEX
None
ip
ip_12
INDEX
None
ip
datestamp_12
INDEX
None
datestamp
adminuser_2
FULLTEXT
None
adminuser
description_2
FULLTEXT
None
description
ip_2
FULLTEXT
None
ip
adminuser_4
FULLTEXT
None
adminuser
ip_3
FULLTEXT
None
ip
description_4
FULLTEXT
None
description
ip_5
FULLTEXT
None
ip
description_5
FULLTEXT
None
description
adminuser_6
FULLTEXT
None
adminuser
adminuser_7
FULLTEXT
None
adminuser
ip_7
FULLTEXT
None
ip
description_8
FULLTEXT
None
description
adminuser_9
FULLTEXT
None
adminuser
ip_9
FULLTEXT
None
ip
adminuser_12
FULLTEXT
None
adminuser
description_11
FULLTEXT
None
description
ip_11
FULLTEXT
None
ip
Create an index on
columns
Space usage:
Type
Usage
Data
240
Bytes
Index
64,512
Bytes
Total
64,752
Bytes
Row Statistic:
Statements
Value
Format
dynamic
Collation
latin1_swedish_ci
Rows
4
Row length ø
60
Row size ø
16,188 Bytes
Next Autoindex
5
Creation
Apr 24, 2018 at 10:59 PM
Last update
Apr 24, 2018 at 10:59 PM
Run SQL query/queries on database puroparty
Fields:
SELECT * FROM `photopost_admlog` WHERE 1
id
adminuser
description
datestamp
ip
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