Server:
mysql.puroparty.com
Database:
puroparty
Table:
bak_core_log_searches
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Field
Type
Collation
Attributes
Null
Default
Extra
Action
search_term
varchar(128)
utf8_general_ci
No
hits
int(11)
UNSIGNED
No
0
Check All
/
Uncheck All
With selected:
Print view
Propose table structure
Add new field:
At End of Table
At Beginning of Table
After
search_term
hits
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
0
search_term
search_term_2
UNIQUE
0
search_term
hits_2
UNIQUE
0
hits
search_term_5
UNIQUE
0
search_term
hits_4
UNIQUE
0
hits
search_term_7
UNIQUE
0
search_term
search_term_9
UNIQUE
0
search_term
hits_7
UNIQUE
0
hits
search_term_11
UNIQUE
0
search_term
hits_9
UNIQUE
0
hits
search_term_14
UNIQUE
0
search_term
hits_11
UNIQUE
0
hits
search_term_15
UNIQUE
0
search_term
search_term_19
UNIQUE
0
search_term
hits_14
UNIQUE
0
hits
hits_15
UNIQUE
0
hits
search_term_22
UNIQUE
0
search_term
search_term_24
UNIQUE
0
search_term
hits_17
UNIQUE
0
hits
hits_18
UNIQUE
0
hits
search_term
INDEX
None
search_term
hits
INDEX
None
hits
search_term_4
INDEX
None
search_term
hits_3
INDEX
None
hits
hits_5
INDEX
None
hits
search_term_8
INDEX
None
search_term
hits_6
INDEX
None
hits
search_term_12
INDEX
None
search_term
hits_8
INDEX
None
hits
hits_10
INDEX
None
hits
hits_12
INDEX
None
hits
search_term_16
INDEX
None
search_term
search_term_18
INDEX
None
search_term
hits_13
INDEX
None
hits
search_term_23
INDEX
None
search_term
hits_16
INDEX
None
hits
search_term_26
INDEX
None
search_term
search_term_3
FULLTEXT
None
search_term
search_term_6
FULLTEXT
None
search_term
search_term_10
FULLTEXT
None
search_term
search_term_13
FULLTEXT
None
search_term
search_term_17
FULLTEXT
None
search_term
search_term_20
FULLTEXT
None
search_term
search_term_21
FULLTEXT
None
search_term
search_term_25
FULLTEXT
None
search_term
search_term_27
FULLTEXT
None
search_term
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 24, 2024 at 03:37 AM
Last update
Apr 24, 2024 at 03:37 AM
Last check
Apr 24, 2024 at 03:37 AM
Run SQL query/queries on database puroparty
Fields:
SELECT * FROM `bak_core_log_searches` WHERE 1
search_term
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