Server:
mysql.puroparty.com
Database:
puroparty
Table:
ads_statistics
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Field
Type
Collation
Attributes
Null
Default
Extra
Action
stat_my
varchar(7)
latin1_swedish_ci
No
stat_item
char(1)
latin1_swedish_ci
No
stat_detail
varchar(10)
latin1_swedish_ci
No
stat_count
float(8,2)
No
0.00
Check All
/
Uncheck All
With selected:
Print view
Propose table structure
Add new field:
At End of Table
At Beginning of Table
After
stat_my
stat_item
stat_detail
stat_count
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
2
stat_item
stat_item_2
UNIQUE
2
stat_item
stat_count_2
UNIQUE
2
stat_count
stat_count_3
UNIQUE
2
stat_count
stat_item_4
UNIQUE
2
stat_item
stat_item_6
UNIQUE
2
stat_item
stat_count_6
UNIQUE
2
stat_count
stat_count_8
UNIQUE
2
stat_count
stat_item_8
UNIQUE
2
stat_item
stat_count_9
UNIQUE
2
stat_count
stat_item_10
UNIQUE
2
stat_item
stat_count_11
UNIQUE
2
stat_count
stat_item_11
UNIQUE
2
stat_item
stat_item_13
UNIQUE
2
stat_item
stat_count_13
UNIQUE
2
stat_count
stat_item_16
UNIQUE
2
stat_item
stat_detail_16
UNIQUE
2
stat_detail
stat_my
INDEX
None
stat_my
stat_item
INDEX
None
stat_item
stat_detail
INDEX
None
stat_detail
stat_count
INDEX
None
stat_count
stat_count_4
INDEX
None
stat_count
stat_item_3
INDEX
None
stat_item
stat_detail_4
INDEX
None
stat_detail
stat_my_4
INDEX
None
stat_my
stat_my_5
INDEX
None
stat_my
stat_item_5
INDEX
None
stat_item
stat_detail_5
INDEX
None
stat_detail
stat_count_5
INDEX
None
stat_count
stat_item_7
INDEX
None
stat_item
stat_detail_8
INDEX
None
stat_detail
stat_count_7
INDEX
None
stat_count
stat_my_8
INDEX
None
stat_my
stat_item_9
INDEX
None
stat_item
stat_detail_10
INDEX
None
stat_detail
stat_count_10
INDEX
None
stat_count
stat_my_10
INDEX
None
stat_my
stat_my_12
INDEX
None
stat_my
stat_item_12
INDEX
None
stat_item
stat_detail_11
INDEX
None
stat_detail
stat_count_12
INDEX
None
stat_count
stat_detail_13
INDEX
None
stat_detail
stat_item_14
INDEX
None
stat_item
stat_count_14
INDEX
None
stat_count
stat_my_14
INDEX
None
stat_my
stat_count_15
INDEX
None
stat_count
stat_my_15
INDEX
None
stat_my
stat_item_15
INDEX
None
stat_item
stat_detail_15
INDEX
None
stat_detail
stat_my_2
FULLTEXT
None
stat_my
stat_detail_2
FULLTEXT
None
stat_detail
stat_detail_3
FULLTEXT
None
stat_detail
stat_my_3
FULLTEXT
None
stat_my
stat_my_6
FULLTEXT
None
stat_my
stat_detail_6
FULLTEXT
None
stat_detail
stat_detail_7
FULLTEXT
None
stat_detail
stat_my_7
FULLTEXT
None
stat_my
stat_detail_9
FULLTEXT
None
stat_detail
stat_my_9
FULLTEXT
None
stat_my
stat_my_11
FULLTEXT
None
stat_my
stat_my_13
FULLTEXT
None
stat_my
stat_detail_12
FULLTEXT
None
stat_detail
stat_detail_14
FULLTEXT
None
stat_detail
stat_my_16
FULLTEXT
None
stat_my
Create an index on
columns
Space usage:
Type
Usage
Data
40
Bytes
Index
3,072
Bytes
Total
3,112
Bytes
Row Statistic:
Statements
Value
Format
dynamic
Collation
latin1_swedish_ci
Rows
2
Row length ø
20
Row size ø
1,556 Bytes
Creation
Apr 10, 2018 at 04:47 AM
Last update
Apr 10, 2018 at 04:47 AM
Run SQL query/queries on database puroparty
Fields:
ALTER TABLE `ads_statistics` ADD INDEX(`stat_item`)
stat_my
stat_item
stat_detail
stat_count
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