Server:
mysql.puroparty.com
Database:
puroparty
Table:
bos_system
An index has been added on item (Query took 0.0096 sec)
SQL-query:
ALTER
TABLE
`bos_system`
ADD
INDEX
(
`item`
)
[
Edit
] [
Create PHP Code
]
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Field
Type
Collation
Attributes
Null
Default
Extra
Action
id
int(2)
No
auto_increment
item
varchar(255)
latin1_swedish_ci
No
value
text
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
item
value
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
46
id
id_2
UNIQUE
46
id
item_2
UNIQUE
46
item
item_6
UNIQUE
46
item
id_4
UNIQUE
46
id
id_6
UNIQUE
46
id
item_8
UNIQUE
46
item
item_11
UNIQUE
46
item
id_8
UNIQUE
46
id
item_13
UNIQUE
46
item
item_15
UNIQUE
46
item
id_11
UNIQUE
46
id
id_12
UNIQUE
46
id
id_14
UNIQUE
46
id
item_20
UNIQUE
46
item
id_16
UNIQUE
46
id
item_25
UNIQUE
46
item
id_18
UNIQUE
46
id
item_28
UNIQUE
46
item
item_29
UNIQUE
46
item
id_21
UNIQUE
46
id
id_22
UNIQUE
46
id
id
INDEX
None
id
item
INDEX
None
item
item_5
INDEX
None
item
id_3
INDEX
None
id
id_5
INDEX
None
id
item_7
INDEX
None
item
id_7
INDEX
None
id
item_12
INDEX
None
item
id_9
INDEX
None
id
id_10
INDEX
None
id
item_17
INDEX
None
item
item_18
INDEX
None
item
id_13
INDEX
None
id
item_19
INDEX
None
item
item_22
INDEX
None
item
id_15
INDEX
None
id
item_23
INDEX
None
item
id_17
INDEX
None
id
item_26
INDEX
None
item
id_19
INDEX
None
id
id_20
INDEX
None
id
item_31
INDEX
None
item
item_32
INDEX
None
item
item_3
FULLTEXT
None
item
value
FULLTEXT
None
value
item_4
FULLTEXT
None
item
value_2
FULLTEXT
None
value
item_9
FULLTEXT
None
item
value_3
FULLTEXT
None
value
item_10
FULLTEXT
None
item
value_4
FULLTEXT
None
value
item_14
FULLTEXT
None
item
value_5
FULLTEXT
None
value
item_16
FULLTEXT
None
item
item_21
FULLTEXT
None
item
value_6
FULLTEXT
None
value
value_7
FULLTEXT
None
value
item_24
FULLTEXT
None
item
value_8
FULLTEXT
None
value
item_27
FULLTEXT
None
item
value_9
FULLTEXT
None
value
item_30
FULLTEXT
None
item
Create an index on
columns
Space usage:
Type
Usage
Data
17,608
Bytes
Index
3,072
Bytes
Total
20,680
Bytes
Row Statistic:
Statements
Value
Format
dynamic
Collation
latin1_swedish_ci
Rows
46
Row length ø
382
Row size ø
450 Bytes
Next Autoindex
93
Creation
Mar 29, 2024 at 07:22 AM
Last update
Mar 29, 2024 at 07:22 AM
Run SQL query/queries on database puroparty
Fields:
SELECT * FROM `bos_system` WHERE 1
id
item
value
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