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

   Field  Type Collation Attributes Null Default Extra Action
   bigint(20)   UNSIGNED No    auto_increment  Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   tinytext utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(200) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   datetime     No  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   datetime     No  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   varchar(20) utf8_general_ci   No    Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(20) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   bigint(20)     No    Change Drop Primary Index Unique Fulltext
   bigint(20)     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 5023  Edit Drop comment_ID
comment_ID_2 UNIQUE 5023  Edit Drop comment_ID
comment_ID_3 UNIQUE 5023  Edit Drop comment_ID
comment_ID_6 UNIQUE 5023  Edit Drop comment_ID
comment_author_url_5 UNIQUE 5023  Edit Drop comment_author_url
comment_approved INDEX None  Edit Drop comment_approved
comment_post_ID INDEX None  Edit Drop comment_post_ID
comment_approved_date_gmt INDEX None  Edit Drop comment_approved
comment_date_gmt
comment_date_gmt INDEX None  Edit Drop comment_date_gmt
comment_ID INDEX None  Edit Drop comment_ID
comment_post_ID_2 INDEX None  Edit Drop comment_post_ID
comment_author_email INDEX None  Edit Drop comment_author_email
comment_author_url INDEX None  Edit Drop comment_author_url
comment_author_IP INDEX None  Edit Drop comment_author_IP
comment_date INDEX None  Edit Drop comment_date
comment_date_gmt_2 INDEX None  Edit Drop comment_date_gmt
comment_karma INDEX None  Edit Drop comment_karma
comment_approved_2 INDEX None  Edit Drop comment_approved
comment_agent INDEX None  Edit Drop comment_agent
comment_type INDEX None  Edit Drop comment_type
comment_parent INDEX None  Edit Drop comment_parent
user_id INDEX None  Edit Drop user_id
comment_approved_4 INDEX None  Edit Drop comment_approved
comment_parent_2 INDEX None  Edit Drop comment_parent
comment_post_ID_3 INDEX None  Edit Drop comment_post_ID
comment_date_gmt_3 INDEX None  Edit Drop comment_date_gmt
comment_author_IP_4 INDEX None  Edit Drop comment_author_IP
comment_karma_2 INDEX None  Edit Drop comment_karma
comment_agent_3 INDEX None  Edit Drop comment_agent
comment_ID_4 INDEX None  Edit Drop comment_ID
comment_date_2 INDEX None  Edit Drop comment_date
comment_author_email_4 INDEX None  Edit Drop comment_author_email
user_id_2 INDEX None  Edit Drop user_id
comment_author_url_4 INDEX None  Edit Drop comment_author_url
comment_type_4 INDEX None  Edit Drop comment_type
comment_ID_5 INDEX None  Edit Drop comment_ID
comment_approved_6 INDEX None  Edit Drop comment_approved
comment_agent_5 INDEX None  Edit Drop comment_agent
comment_parent_3 INDEX None  Edit Drop comment_parent
comment_date_3 INDEX None  Edit Drop comment_date
comment_date_gmt_4 INDEX None  Edit Drop comment_date_gmt
comment_post_ID_4 INDEX None  Edit Drop comment_post_ID
comment_author_IP_6 INDEX None  Edit Drop comment_author_IP
comment_author FULLTEXT None  Edit Drop comment_author
comment_author_email_2 FULLTEXT None  Edit Drop comment_author_email
comment_author_url_2 FULLTEXT None  Edit Drop comment_author_url
comment_author_IP_2 FULLTEXT None  Edit Drop comment_author_IP
comment_content FULLTEXT None  Edit Drop comment_content
comment_approved_3 FULLTEXT None  Edit Drop comment_approved
comment_agent_2 FULLTEXT None  Edit Drop comment_agent
comment_type_2 FULLTEXT None  Edit Drop comment_type
comment_content_2 FULLTEXT None  Edit Drop comment_content
comment_author_email_3 FULLTEXT None  Edit Drop comment_author_email
comment_author_IP_3 FULLTEXT None  Edit Drop comment_author_IP
comment_author_url_3 FULLTEXT None  Edit Drop comment_author_url
comment_type_3 FULLTEXT None  Edit Drop comment_type
comment_approved_5 FULLTEXT None  Edit Drop comment_approved
comment_agent_4 FULLTEXT None  Edit Drop comment_agent
comment_author_2 FULLTEXT None  Edit Drop comment_author
comment_author_email_5 FULLTEXT None  Edit Drop comment_author_email
comment_approved_7 FULLTEXT None  Edit Drop comment_approved
comment_content_3 FULLTEXT None  Edit Drop comment_content
comment_author_IP_5 FULLTEXT None  Edit Drop comment_author_IP
comment_type_5 FULLTEXT None  Edit Drop comment_type
Create an index on  columns  
 
Space usage: 
Type Usage
Data 8,862 KB
Index 4,096 Bytes
Total 8,866 KB
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Rows 5,023
Row length ø 1,806
Row size  ø 1,808 Bytes
Next Autoindex 5,024
Creation Dec 14, 2017 at 05:53 PM
Last update Dec 14, 2017 at 05:53 PM

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: