Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: poll_commentpoll_comment

   Field  Type Collation Attributes Null Default Extra Action
   int(9)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   int(9)     No    Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(255) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(60) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   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 com_id
com_id_2 UNIQUE Edit Drop com_id
time_2 UNIQUE Edit Drop time
host_2 UNIQUE Edit Drop host
browser_2 UNIQUE Edit Drop browser
name_2 UNIQUE Edit Drop name
email_2 UNIQUE Edit Drop email
browser_4 UNIQUE Edit Drop browser
com_id_3 UNIQUE Edit Drop com_id
email_6 UNIQUE Edit Drop email
name_6 UNIQUE Edit Drop name
time_4 UNIQUE Edit Drop time
host_6 UNIQUE Edit Drop host
com_id_5 UNIQUE Edit Drop com_id
com_id_6 UNIQUE Edit Drop com_id
browser_7 UNIQUE Edit Drop browser
email_8 UNIQUE Edit Drop email
time_5 UNIQUE Edit Drop time
host_9 UNIQUE Edit Drop host
name_9 UNIQUE Edit Drop name
com_id_8 UNIQUE Edit Drop com_id
browser_10 UNIQUE Edit Drop browser
email_11 UNIQUE Edit Drop email
com_id INDEX None  Edit Drop com_id
poll_id INDEX None  Edit Drop poll_id
time INDEX None  Edit Drop time
host INDEX None  Edit Drop host
browser INDEX None  Edit Drop browser
name INDEX None  Edit Drop name
email INDEX None  Edit Drop email
poll_id_2 INDEX None  Edit Drop poll_id
host_5 INDEX None  Edit Drop host
browser_5 INDEX None  Edit Drop browser
email_5 INDEX None  Edit Drop email
name_5 INDEX None  Edit Drop name
com_id_4 INDEX None  Edit Drop com_id
time_3 INDEX None  Edit Drop time
poll_id_3 INDEX None  Edit Drop poll_id
browser_8 INDEX None  Edit Drop browser
name_8 INDEX None  Edit Drop name
host_8 INDEX None  Edit Drop host
email_9 INDEX None  Edit Drop email
com_id_7 INDEX None  Edit Drop com_id
time_6 INDEX None  Edit Drop time
poll_id_4 INDEX None  Edit Drop poll_id
host_3 FULLTEXT None  Edit Drop host
browser_3 FULLTEXT None  Edit Drop browser
name_3 FULLTEXT None  Edit Drop name
email_3 FULLTEXT None  Edit Drop email
message FULLTEXT None  Edit Drop message
name_4 FULLTEXT None  Edit Drop name
host_4 FULLTEXT None  Edit Drop host
email_4 FULLTEXT None  Edit Drop email
browser_6 FULLTEXT None  Edit Drop browser
message_2 FULLTEXT None  Edit Drop message
email_7 FULLTEXT None  Edit Drop email
name_7 FULLTEXT None  Edit Drop name
host_7 FULLTEXT None  Edit Drop host
browser_9 FULLTEXT None  Edit Drop browser
message_3 FULLTEXT None  Edit Drop message
name_10 FULLTEXT None  Edit Drop name
email_10 FULLTEXT None  Edit Drop email
host_10 FULLTEXT None  Edit Drop host
browser_11 FULLTEXT None  Edit Drop browser
Create an index on  columns  
 
Space usage: 
Type Usage
Data 904 Bytes
Index 3,072 Bytes
Total 3,976 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 4
Row length ø 226
Row size  ø 994 Bytes
Next Autoindex 5
Creation Mar 20, 2018 at 12:18 AM
Last update Mar 20, 2018 at 12:18 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: