Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: wp_5_postswp_5_posts
StructureStructure BrowseBrowse SQLSQL SearchSearch InsertInsert ExportExport OperationsOperations EmptyEmpty DropDrop

SQL-query
SQL-query: 
SELECT *
FROM `wp_5_posts`
PROCEDURE ANALYSE ( )
 [Edit] [Explain SQL] [Create PHP Code] [Refresh]



Field_name Min_value Max_value Min_length Max_length Empties_or_zeros Nulls Avg_value_or_avg_length Std Optimal_fieldtype
puroparty.wp_5_posts.ID 1 5 1 1 0 0 3.0000 1.4142 ENUM('1','2','3','4','5') NOT NULL
puroparty.wp_5_posts.post_author 1 4 1 1 0 0 3.4000 1.2000 ENUM('1','4') NOT NULL
puroparty.wp_5_posts.post_date 2008-08-09 12:28:18 2008-08-12 00:10:22 19 19 0 0 19.0000 NULL ENUM('2008-08-09 12:28:18','2008-08-09 13:07:23','...
puroparty.wp_5_posts.post_date_gmt 2008-08-09 17:28:18 2008-08-12 05:10:22 19 19 0 0 19.0000 NULL ENUM('2008-08-09 17:28:18','2008-08-09 18:07:23','...
puroparty.wp_5_posts.post_content i dunno what this is who cares! what is this country coming to?  the me... 11 269 0 0 127.0000 NULL ENUM('i dunno what this is','spacer test','This is...
puroparty.wp_5_posts.post_title About john edwards does a no-no 5 25 0 0 11.4000 NULL ENUM('About','blog3','dunno page','Hello world!','...
puroparty.wp_5_posts.post_category 0 0 1 1 5 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.wp_5_posts.post_excerpt     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_5_posts.post_status publish publish 7 7 0 0 7.0000 NULL ENUM('publish') NOT NULL
puroparty.wp_5_posts.comment_status open open 4 4 0 0 4.0000 NULL ENUM('open') NOT NULL
puroparty.wp_5_posts.ping_status open open 4 4 0 0 4.0000 NULL ENUM('open') NOT NULL
puroparty.wp_5_posts.post_password     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_5_posts.post_name about john-edwards-does-a-no-no 5 25 0 0 11.2000 NULL ENUM('about','blog3','dunno-page','hello-world','j...
puroparty.wp_5_posts.to_ping     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_5_posts.pinged     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_5_posts.post_modified 2008-08-09 12:28:18 2008-08-12 00:10:22 19 19 0 0 19.0000 NULL ENUM('2008-08-09 12:28:18','2008-08-09 13:07:23','...
puroparty.wp_5_posts.post_modified_gmt 2008-08-09 17:28:18 2008-08-12 05:10:22 19 19 0 0 19.0000 NULL ENUM('2008-08-09 17:28:18','2008-08-09 18:07:23','...
puroparty.wp_5_posts.post_content_filtered     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_5_posts.post_parent 0 0 1 1 5 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.wp_5_posts.guid   http://puroparty.com/ppblogs/dryzzl/?page_id=4 0 53 2 0 27.8000 NULL ENUM('','http://puroparty.com/ppblogs/dryzzl/2008/...
puroparty.wp_5_posts.menu_order 0 0 1 1 5 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.wp_5_posts.post_type page post 4 4 0 0 4.0000 NULL ENUM('page','post') NOT NULL
puroparty.wp_5_posts.post_mime_type     0 0 5 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_5_posts.comment_count 1 1 1 1 3 0 0.4000 0.4899 ENUM('0','1') NOT NULL


Print viewPrint view    Print view (with full texts)Print view (with full texts)     ExportExport