Server:
mysql.puroparty.com
Database:
puroparty
Table:
bak_stats_agents
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Field
Type
Collation
Attributes
Null
Default
Extra
Action
agent
varchar(255)
utf8_general_ci
No
type
tinyint(1)
UNSIGNED
No
0
hits
int(11)
UNSIGNED
No
1
Check All
/
Uncheck All
With selected:
Print view
Propose table structure
Add new field:
At End of Table
At Beginning of Table
After
agent
type
hits
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
0
agent
agent_2
UNIQUE
0
agent
type_2
UNIQUE
0
type
hits_2
UNIQUE
0
hits
type_3
UNIQUE
0
type
hits_4
UNIQUE
0
hits
agent_5
UNIQUE
0
agent
agent_9
UNIQUE
0
agent
type_5
UNIQUE
0
type
hits_6
UNIQUE
0
hits
agent_11
UNIQUE
0
agent
type_8
UNIQUE
0
type
hits_8
UNIQUE
0
hits
hits_9
UNIQUE
0
hits
agent_13
UNIQUE
0
agent
type_9
UNIQUE
0
type
hits_11
UNIQUE
0
hits
hits_12
UNIQUE
0
hits
agent_17
UNIQUE
0
agent
agent_19
UNIQUE
0
agent
type_11
UNIQUE
0
type
type_13
UNIQUE
0
type
agent_22
UNIQUE
0
agent
type_16
UNIQUE
0
type
hits_15
UNIQUE
0
hits
agent_25
UNIQUE
0
agent
hits_16
UNIQUE
0
hits
hits_18
UNIQUE
0
hits
type_17
UNIQUE
0
type
agent_27
UNIQUE
0
agent
agent
INDEX
None
agent
type
INDEX
None
type
hits
INDEX
None
hits
hits_3
INDEX
None
hits
type_4
INDEX
None
type
agent_4
INDEX
None
agent
agent_8
INDEX
None
agent
hits_5
INDEX
None
hits
type_6
INDEX
None
type
agent_10
INDEX
None
agent
type_7
INDEX
None
type
hits_7
INDEX
None
hits
hits_10
INDEX
None
hits
type_10
INDEX
None
type
agent_14
INDEX
None
agent
agent_16
INDEX
None
agent
type_12
INDEX
None
type
type_14
INDEX
None
type
hits_13
INDEX
None
hits
agent_20
INDEX
None
agent
agent_21
INDEX
None
agent
type_15
INDEX
None
type
hits_14
INDEX
None
hits
hits_17
INDEX
None
hits
agent_26
INDEX
None
agent
agent_3
FULLTEXT
None
agent
agent_6
FULLTEXT
None
agent
agent_7
FULLTEXT
None
agent
agent_12
FULLTEXT
None
agent
agent_15
FULLTEXT
None
agent
agent_18
FULLTEXT
None
agent
agent_23
FULLTEXT
None
agent
agent_24
FULLTEXT
None
agent
agent_28
FULLTEXT
None
agent
Create an index on
columns
Space usage:
Type
Usage
Data
0
Bytes
Index
3,072
Bytes
Total
3,072
Bytes
Row Statistic:
Statements
Value
Format
dynamic
Collation
utf8_general_ci
Rows
0
Creation
Apr 25, 2024 at 06:16 PM
Last update
Jun 01, 2024 at 08:25 PM
Last check
Jun 01, 2024 at 11:03 PM
Run SQL query/queries on database puroparty
Fields:
SELECT * FROM `bak_stats_agents` WHERE 1
agent
type
hits
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