Server:
mysql.puroparty.com
Database:
puroparty
Table:
poll_index
An index has been added on status (Query took 0.0092 sec)
SQL-query:
ALTER
TABLE
`poll_index`
ADD
INDEX
(
`status`
)
[
Edit
] [
Create PHP Code
]
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Field
Type
Collation
Attributes
Null
Default
Extra
Action
poll_id
int(11)
UNSIGNED
No
auto_increment
question
varchar(100)
latin1_swedish_ci
No
timestamp
int(11)
No
0
status
smallint(2)
No
0
logging
smallint(2)
No
0
exp_time
int(11)
No
0
expire
smallint(2)
No
0
comments
smallint(2)
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
poll_id
question
timestamp
status
logging
exp_time
expire
comments
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
4
poll_id
poll_id_2
UNIQUE
4
poll_id
question_2
UNIQUE
4
question
poll_id_3
UNIQUE
4
poll_id
question_4
UNIQUE
4
question
poll_id_5
UNIQUE
4
poll_id
question_8
UNIQUE
4
question
poll_id_7
UNIQUE
4
poll_id
question_10
UNIQUE
4
question
poll_id_10
UNIQUE
4
poll_id
question_14
UNIQUE
4
question
poll_id_11
UNIQUE
4
poll_id
poll_id
INDEX
None
poll_id
question
INDEX
None
question
timestamp
INDEX
None
timestamp
status
INDEX
None
status
logging
INDEX
None
logging
exp_time
INDEX
None
exp_time
expire
INDEX
None
expire
comments
INDEX
None
comments
exp_time_2
INDEX
None
exp_time
expire_2
INDEX
None
expire
timestamp_2
INDEX
None
timestamp
question_6
INDEX
None
question
status_2
INDEX
None
status
comments_2
INDEX
None
comments
poll_id_4
INDEX
None
poll_id
logging_2
INDEX
None
logging
exp_time_3
INDEX
None
exp_time
timestamp_3
INDEX
None
timestamp
expire_3
INDEX
None
expire
question_7
INDEX
None
question
status_3
INDEX
None
status
comments_3
INDEX
None
comments
poll_id_6
INDEX
None
poll_id
logging_3
INDEX
None
logging
exp_time_4
INDEX
None
exp_time
timestamp_4
INDEX
None
timestamp
comments_4
INDEX
None
comments
expire_4
INDEX
None
expire
question_11
INDEX
None
question
status_4
INDEX
None
status
logging_4
INDEX
None
logging
poll_id_8
INDEX
None
poll_id
poll_id_9
INDEX
None
poll_id
question_13
INDEX
None
question
timestamp_5
INDEX
None
timestamp
status_5
INDEX
None
status
logging_5
INDEX
None
logging
exp_time_5
INDEX
None
exp_time
expire_5
INDEX
None
expire
comments_5
INDEX
None
comments
timestamp_6
INDEX
None
timestamp
exp_time_6
INDEX
None
exp_time
timestamp_7
INDEX
None
timestamp
status_6
INDEX
None
status
question_3
FULLTEXT
None
question
question_5
FULLTEXT
None
question
question_9
FULLTEXT
None
question
question_12
FULLTEXT
None
question
question_15
FULLTEXT
None
question
Create an index on
columns
Space usage:
Type
Usage
Data
240
Bytes
Index
65,536
Bytes
Total
65,776
Bytes
Row Statistic:
Statements
Value
Format
dynamic
Collation
latin1_swedish_ci
Rows
4
Row length ø
60
Row size ø
16,444 Bytes
Next Autoindex
5
Creation
Mar 29, 2024 at 11:11 AM
Last update
Mar 29, 2024 at 11:11 AM
Run SQL query/queries on database puroparty
Fields:
SELECT * FROM `poll_index` WHERE 1
poll_id
question
timestamp
status
logging
exp_time
expire
comments
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