Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: poll_indexpoll_index
An index has been added on timestamp (Query took 0.0042 sec)
SQL-query: 
ALTER TABLE `poll_index` ADD INDEX ( `timestamp` )
 [Edit] [Create PHP Code]


   Field  Type Collation Attributes Null Default Extra Action
   int(11)   UNSIGNED No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   smallint(2)     No    Change Drop Primary Index Unique Fulltext
   smallint(2)     No    Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   smallint(2)     No    Change Drop Primary Index Unique Fulltext
   smallint(2)     No    Change Drop Primary Index Unique Fulltext
With selected: Check All  /  Uncheck All     With selected:  

Print viewPrint view    Propose table structurePropose table structureDocumentation
Add new fieldAdd new field: 

Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY Edit Drop poll_id
poll_id_2 UNIQUE Edit Drop poll_id
question_2 UNIQUE Edit Drop question
poll_id_3 UNIQUE Edit Drop poll_id
question_4 UNIQUE Edit Drop question
poll_id_5 UNIQUE Edit Drop poll_id
question_8 UNIQUE Edit Drop question
poll_id_7 UNIQUE Edit Drop poll_id
question_10 UNIQUE Edit Drop question
poll_id_10 UNIQUE Edit Drop poll_id
question_14 UNIQUE Edit Drop question
poll_id_11 UNIQUE Edit Drop poll_id
poll_id INDEX None  Edit Drop poll_id
question INDEX None  Edit Drop question
timestamp INDEX None  Edit Drop timestamp
status INDEX None  Edit Drop status
logging INDEX None  Edit Drop logging
exp_time INDEX None  Edit Drop exp_time
expire INDEX None  Edit Drop expire
comments INDEX None  Edit Drop comments
exp_time_2 INDEX None  Edit Drop exp_time
expire_2 INDEX None  Edit Drop expire
timestamp_2 INDEX None  Edit Drop timestamp
question_6 INDEX None  Edit Drop question
status_2 INDEX None  Edit Drop status
comments_2 INDEX None  Edit Drop comments
poll_id_4 INDEX None  Edit Drop poll_id
logging_2 INDEX None  Edit Drop logging
exp_time_3 INDEX None  Edit Drop exp_time
timestamp_3 INDEX None  Edit Drop timestamp
expire_3 INDEX None  Edit Drop expire
question_7 INDEX None  Edit Drop question
status_3 INDEX None  Edit Drop status
comments_3 INDEX None  Edit Drop comments
poll_id_6 INDEX None  Edit Drop poll_id
logging_3 INDEX None  Edit Drop logging
exp_time_4 INDEX None  Edit Drop exp_time
timestamp_4 INDEX None  Edit Drop timestamp
comments_4 INDEX None  Edit Drop comments
expire_4 INDEX None  Edit Drop expire
question_11 INDEX None  Edit Drop question
status_4 INDEX None  Edit Drop status
logging_4 INDEX None  Edit Drop logging
poll_id_8 INDEX None  Edit Drop poll_id
poll_id_9 INDEX None  Edit Drop poll_id
question_13 INDEX None  Edit Drop question
timestamp_5 INDEX None  Edit Drop timestamp
status_5 INDEX None  Edit Drop status
logging_5 INDEX None  Edit Drop logging
exp_time_5 INDEX None  Edit Drop exp_time
expire_5 INDEX None  Edit Drop expire
comments_5 INDEX None  Edit Drop comments
timestamp_6 INDEX None  Edit Drop timestamp
question_3 FULLTEXT None  Edit Drop question
question_5 FULLTEXT None  Edit Drop question
question_9 FULLTEXT None  Edit Drop question
question_12 FULLTEXT None  Edit Drop question
question_15 FULLTEXT None  Edit Drop question
Create an index on  columns  
 
Space usage: 
Type Usage
Data 240 Bytes
Index 62,464 Bytes
Total 62,704 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 4
Row length ø 60
Row size  ø 15,676 Bytes
Next Autoindex 5
Creation Jun 22, 2018 at 03:38 AM
Last update Jun 22, 2018 at 03:38 AM

Run SQL query/queries on database puropartyDocumentation     Fields: 
Or Location of the textfile: 
 Location of the textfile: 
   (Max: 2,048KB)
  Compression:
                
Character set of the file: