Server:
mysql.puroparty.com
Database:
puroparty
Table:
jos_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_3
UNIQUE
0
hits
agent_6
UNIQUE
0
agent
type_5
UNIQUE
0
type
agent_7
UNIQUE
0
agent
hits_6
UNIQUE
0
hits
type_7
UNIQUE
0
type
hits_8
UNIQUE
0
hits
agent_11
UNIQUE
0
agent
type_9
UNIQUE
0
type
hits_10
UNIQUE
0
hits
agent_16
UNIQUE
0
agent
type_11
UNIQUE
0
type
hits_12
UNIQUE
0
hits
agent_18
UNIQUE
0
agent
type_14
UNIQUE
0
type
hits_14
UNIQUE
0
hits
agent_20
UNIQUE
0
agent
hits_15
UNIQUE
0
hits
agent
INDEX
None
agent
type
INDEX
None
type
hits
INDEX
None
hits
hits_4
INDEX
None
hits
agent_4
INDEX
None
agent
type_4
INDEX
None
type
hits_5
INDEX
None
hits
type_6
INDEX
None
type
agent_9
INDEX
None
agent
agent_10
INDEX
None
agent
type_8
INDEX
None
type
hits_7
INDEX
None
hits
agent_13
INDEX
None
agent
hits_9
INDEX
None
hits
agent_14
INDEX
None
agent
type_10
INDEX
None
type
hits_11
INDEX
None
hits
type_12
INDEX
None
type
agent_17
INDEX
None
agent
type_13
INDEX
None
type
hits_13
INDEX
None
hits
agent_22
INDEX
None
agent
type_15
INDEX
None
type
agent_3
FULLTEXT
None
agent
agent_5
FULLTEXT
None
agent
agent_8
FULLTEXT
None
agent
agent_12
FULLTEXT
None
agent
agent_15
FULLTEXT
None
agent
agent_19
FULLTEXT
None
agent
agent_21
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 17, 2024 at 11:13 AM
Last update
Apr 17, 2024 at 11:13 AM
Last check
Apr 17, 2024 at 11:13 AM
Run SQL query/queries on database puroparty
Fields:
ALTER TABLE `jos_stats_agents` ADD PRIMARY KEY(`agent`)
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