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

SQL-query
SQL-query: 
SELECT *
FROM `wp_2_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_2_posts.ID 1 9 1 1 0 0 5.0000 2.5820 ENUM('1','2','3','4','5','6','7','8','9') NOT NULL
puroparty.wp_2_posts.post_author 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL
puroparty.wp_2_posts.post_date 0000-00-00 00:00:00 2008-09-05 00:01:45 19 19 0 0 19.0000 NULL ENUM('0000-00-00 00:00:00','2008-08-05 15:50:46','...
puroparty.wp_2_posts.post_date_gmt 0000-00-00 00:00:00 2008-09-05 05:01:45 19 19 0 0 19.0000 NULL ENUM('0000-00-00 00:00:00','2008-08-05 20:50:46','...
puroparty.wp_2_posts.post_content <object width="425" height="344"><param n... xxx 3 568 2 0 111.0000 NULL ENUM('','<object width="425" height="344">&l...
puroparty.wp_2_posts.post_title About xxx 3 12 0 0 6.6667 NULL ENUM('About','Hello world!','music 2','music 3','m...
puroparty.wp_2_posts.post_category 0 0 1 1 9 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.wp_2_posts.post_excerpt     0 0 9 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_2_posts.post_status draft publish 5 7 0 0 5.8889 NULL ENUM('draft','publish') NOT NULL
puroparty.wp_2_posts.comment_status open open 4 4 0 0 4.0000 NULL ENUM('open') NOT NULL
puroparty.wp_2_posts.ping_status open open 4 4 0 0 4.0000 NULL ENUM('open') NOT NULL
puroparty.wp_2_posts.post_password     0 0 9 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_2_posts.post_name about test2 5 11 5 0 3.0000 NULL ENUM('','about','hello-world','test-4','test2') NO...
puroparty.wp_2_posts.to_ping     0 0 9 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_2_posts.pinged     0 0 9 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_2_posts.post_modified 2008-08-05 15:50:46 2008-09-05 00:01:45 19 19 0 0 19.0000 NULL ENUM('2008-08-05 15:50:46','2008-08-19 16:44:22','...
puroparty.wp_2_posts.post_modified_gmt 2008-08-05 20:50:46 2008-09-05 05:01:45 19 19 0 0 19.0000 NULL ENUM('2008-08-05 20:50:46','2008-08-19 21:44:22','...
puroparty.wp_2_posts.post_content_filtered     0 0 9 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_2_posts.post_parent 0 0 1 1 9 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.wp_2_posts.guid   http://puroparty.com/ppblogs/politico/?p=9 0 42 2 0 32.6667 NULL ENUM('','http://puroparty.com/ppblogs/politico/?p=...
puroparty.wp_2_posts.menu_order 0 0 1 1 9 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.wp_2_posts.post_type page post 4 4 0 0 4.0000 NULL ENUM('page','post') NOT NULL
puroparty.wp_2_posts.post_mime_type     0 0 9 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_2_posts.comment_count 1 1 1 1 8 0 0.1111 0.3143 ENUM('0','1') NOT NULL


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