Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: wp_1_commentswp_1_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 54  Edit Drop comment_ID
comment_ID_2 UNIQUE 54  Edit Drop comment_ID
comment_date_2 UNIQUE 54  Edit Drop comment_date
comment_date_gmt_3 UNIQUE 54  Edit Drop comment_date_gmt
comment_date_4 UNIQUE 54  Edit Drop comment_date
comment_date_gmt_5 UNIQUE 54  Edit Drop comment_date_gmt
comment_ID_3 UNIQUE 54  Edit Drop comment_ID
comment_date_gmt_6 UNIQUE 54  Edit Drop comment_date_gmt
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_date_3 INDEX None  Edit Drop comment_date
comment_approved_4 INDEX None  Edit Drop comment_approved
comment_date_gmt_4 INDEX None  Edit Drop comment_date_gmt
comment_karma_2 INDEX None  Edit Drop comment_karma
comment_agent_3 INDEX None  Edit Drop comment_agent
comment_post_ID_3 INDEX None  Edit Drop comment_post_ID
user_id_2 INDEX None  Edit Drop user_id
comment_author_IP_3 INDEX None  Edit Drop comment_author_IP
comment_author_url_3 INDEX None  Edit Drop comment_author_url
comment_ID_4 INDEX None  Edit Drop comment_ID
comment_parent_2 INDEX None  Edit Drop comment_parent
comment_type_4 INDEX None  Edit Drop comment_type
comment_author_email_4 INDEX None  Edit Drop comment_author_email
comment_approved_6 INDEX None  Edit Drop comment_approved
comment_approved_7 INDEX None  Edit Drop comment_approved
comment_date_5 INDEX None  Edit Drop comment_date
comment_agent_5 INDEX None  Edit Drop comment_agent
user_id_3 INDEX None  Edit Drop user_id
comment_post_ID_4 INDEX None  Edit Drop comment_post_ID
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_author_email_3 FULLTEXT None  Edit Drop comment_author_email
comment_content_2 FULLTEXT None  Edit Drop comment_content
comment_approved_5 FULLTEXT None  Edit Drop comment_approved
comment_author_IP_4 FULLTEXT None  Edit Drop comment_author_IP
comment_type_3 FULLTEXT None  Edit Drop comment_type
comment_author_2 FULLTEXT None  Edit Drop comment_author
comment_agent_4 FULLTEXT None  Edit Drop comment_agent
comment_author_url_4 FULLTEXT None  Edit Drop comment_author_url
comment_author_IP_5 FULLTEXT None  Edit Drop comment_author_IP
comment_type_5 FULLTEXT None  Edit Drop comment_type
comment_approved_8 FULLTEXT None  Edit Drop comment_approved
comment_content_3 FULLTEXT None  Edit Drop comment_content
Create an index on  columns  
 
Space usage: 
Type Usage
Data 19,452 Bytes
Index 4,096 Bytes
Total 23,548 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Rows 54
Row length ø 360
Row size  ø 436 Bytes
Next Autoindex 55
Creation Dec 14, 2017 at 08:30 AM
Last update Dec 14, 2017 at 08:30 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: