Server:
mysql.puroparty.com
Database:
puroparty
Table:
photopost_sort
An index has been added on name (Query took 0.0103 sec)
SQL-query:
ALTER
TABLE
`photopost_sort`
ADD
INDEX
(
`name`
)
[
Edit
] [
Create PHP Code
]
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Field
Type
Collation
Attributes
Null
Default
Extra
Action
sortid
int(15)
No
auto_increment
name
varchar(35)
latin1_swedish_ci
No
code
varchar(75)
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
sortid
name
code
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
8
sortid
sortid_2
UNIQUE
8
sortid
name_2
UNIQUE
8
name
code_2
UNIQUE
8
code
code_4
UNIQUE
8
code
name_6
UNIQUE
8
name
sortid_4
UNIQUE
8
sortid
code_8
UNIQUE
8
code
sortid_6
UNIQUE
8
sortid
name_9
UNIQUE
8
name
code_11
UNIQUE
8
code
name_11
UNIQUE
8
name
sortid_8
UNIQUE
8
sortid
code_14
UNIQUE
8
code
name_14
UNIQUE
8
name
sortid_10
UNIQUE
8
sortid
sortid_12
UNIQUE
8
sortid
name_17
UNIQUE
8
name
code_17
UNIQUE
8
code
code_19
UNIQUE
8
code
name_20
UNIQUE
8
name
sortid
INDEX
None
sortid
name
INDEX
None
name
code
INDEX
None
code
name_4
INDEX
None
name
code_6
INDEX
None
code
sortid_3
INDEX
None
sortid
code_7
INDEX
None
code
name_8
INDEX
None
name
sortid_5
INDEX
None
sortid
code_10
INDEX
None
code
name_10
INDEX
None
name
sortid_7
INDEX
None
sortid
code_13
INDEX
None
code
name_13
INDEX
None
name
sortid_9
INDEX
None
sortid
sortid_11
INDEX
None
sortid
name_16
INDEX
None
name
code_16
INDEX
None
code
name_19
INDEX
None
name
code_20
INDEX
None
code
name_21
INDEX
None
name
name_3
FULLTEXT
None
name
code_3
FULLTEXT
None
code
name_5
FULLTEXT
None
name
code_5
FULLTEXT
None
code
name_7
FULLTEXT
None
name
code_9
FULLTEXT
None
code
code_12
FULLTEXT
None
code
name_12
FULLTEXT
None
name
code_15
FULLTEXT
None
code
name_15
FULLTEXT
None
name
name_18
FULLTEXT
None
name
code_18
FULLTEXT
None
code
code_21
FULLTEXT
None
code
Create an index on
columns
Space usage:
Type
Usage
Data
404
Bytes
Index
59,392
Bytes
Total
59,796
Bytes
Row Statistic:
Statements
Value
Format
dynamic
Collation
latin1_swedish_ci
Rows
8
Row length ø
50
Row size ø
7,475 Bytes
Next Autoindex
9
Creation
Apr 24, 2024 at 07:41 PM
Last update
Apr 24, 2024 at 07:41 PM
Run SQL query/queries on database puroparty
Fields:
SELECT * FROM `photopost_sort` WHERE 1
sortid
name
code
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