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

SQL-query
SQL-query: 
SELECT *
FROM `wp_9_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_9_posts.ID 1 3 1 1 0 0 2.0000 0.8165 ENUM('1','2','3') NOT NULL
puroparty.wp_9_posts.post_author 1 5 1 1 0 0 3.6667 1.8856 ENUM('1','5') NOT NULL
puroparty.wp_9_posts.post_date 2008-09-05 00:05:25 2008-09-05 01:04:04 19 19 0 0 19.0000 NULL ENUM('2008-09-05 00:05:25','2008-09-05 01:04:04') ...
puroparty.wp_9_posts.post_date_gmt 2008-09-05 05:05:25 2008-09-05 06:04:04 19 19 0 0 19.0000 NULL ENUM('2008-09-05 05:05:25','2008-09-05 06:04:04') ...
puroparty.wp_9_posts.post_content <strong>CNN)</strong> -- Sen. John McCain got one ... Welcome to <a href="http://puroparty.com/ppblogs/"... 136 2920 0 0 1108.3333 NULL ENUM('<strong>CNN)</strong> -- Sen. John McCain go...
puroparty.wp_9_posts.post_title About McCain at GOP Convention 5 24 0 0 13.6667 NULL ENUM('About','Hello world!','McCain at GOP Convent...
puroparty.wp_9_posts.post_category 0 0 1 1 3 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.wp_9_posts.post_excerpt     0 0 3 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_9_posts.post_status publish publish 7 7 0 0 7.0000 NULL ENUM('publish') NOT NULL
puroparty.wp_9_posts.comment_status open open 4 4 0 0 4.0000 NULL ENUM('open') NOT NULL
puroparty.wp_9_posts.ping_status open open 4 4 0 0 4.0000 NULL ENUM('open') NOT NULL
puroparty.wp_9_posts.post_password     0 0 3 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_9_posts.post_name about mccain-at-gop-convention 5 24 0 0 13.3333 NULL ENUM('about','hello-world','mccain-at-gop-conventi...
puroparty.wp_9_posts.to_ping     0 0 3 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_9_posts.pinged     0 0 3 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_9_posts.post_modified 2008-09-05 00:05:25 2008-09-05 01:04:04 19 19 0 0 19.0000 NULL ENUM('2008-09-05 00:05:25','2008-09-05 01:04:04') ...
puroparty.wp_9_posts.post_modified_gmt 2008-09-05 05:05:25 2008-09-05 06:04:04 19 19 0 0 19.0000 NULL ENUM('2008-09-05 05:05:25','2008-09-05 06:04:04') ...
puroparty.wp_9_posts.post_content_filtered     0 0 3 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_9_posts.post_parent 0 0 1 1 3 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.wp_9_posts.guid   http://puroparty.com/ppblogs/mccain/?p=3 0 40 2 0 13.3333 NULL ENUM('','http://puroparty.com/ppblogs/mccain/?p=3'...
puroparty.wp_9_posts.menu_order 0 0 1 1 3 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.wp_9_posts.post_type page post 4 4 0 0 4.0000 NULL ENUM('page','post') NOT NULL
puroparty.wp_9_posts.post_mime_type     0 0 3 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_9_posts.comment_count 1 1 1 1 2 0 0.3333 0.4714 ENUM('0','1') NOT NULL


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