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

SQL-query
SQL-query: 
SELECT *
FROM `wp_7_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_7_posts.ID 1 22 1 2 0 0 12.1667 6.5000 ENUM('1','2','4','5','7','8','9','11','12','13','1...
puroparty.wp_7_posts.post_author 5 5 1 1 0 0 5.0000 0.0000 ENUM('5') NOT NULL
puroparty.wp_7_posts.post_date 2008-08-12 15:24:36 2008-08-12 17:29:36 19 19 0 0 19.0000 NULL ENUM('2008-08-12 15:24:36','2008-08-12 15:55:57','...
puroparty.wp_7_posts.post_date_gmt 2008-08-12 20:24:36 2008-08-12 22:29:36 19 19 0 0 19.0000 NULL ENUM('2008-08-12 20:24:36','2008-08-12 20:55:57','...
puroparty.wp_7_posts.post_content <a href="http://puroparty.com/ppblogs/index/files/... Welcome to <a href="http://puroparty.com/ppblogs/"... 7 836 7 0 164.1667 NULL ENUM('','<a href="http://puroparty.com/ppblogs/ind...
puroparty.wp_7_posts.post_title About title thalia 4 22 0 0 10.7778 NULL ENUM('About','Hello world!','sodi','thalia','Thali...
puroparty.wp_7_posts.post_category 0 0 1 1 18 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.wp_7_posts.post_excerpt   Thalia Sodi 0 14 10 0 5.2778 NULL ENUM('','caption thalia','th cap','thalia caption'...
puroparty.wp_7_posts.post_status inherit publish 7 7 0 0 7.0000 NULL ENUM('inherit','publish') NOT NULL
puroparty.wp_7_posts.comment_status open open 4 4 0 0 4.0000 NULL ENUM('open') NOT NULL
puroparty.wp_7_posts.ping_status open open 4 4 0 0 4.0000 NULL ENUM('open') NOT NULL
puroparty.wp_7_posts.post_password     0 0 18 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_7_posts.post_name about thalia8-12-20084 4 17 0 0 10.2778 NULL ENUM('about','hello-world','sodi','thalia','thalia...
puroparty.wp_7_posts.to_ping     0 0 18 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_7_posts.pinged     0 0 18 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_7_posts.post_modified 2008-08-12 15:24:36 2008-08-12 23:28:06 19 19 0 0 19.0000 NULL ENUM('2008-08-12 15:24:36','2008-08-12 15:55:57','...
puroparty.wp_7_posts.post_modified_gmt 2008-08-12 20:24:36 2008-08-13 04:28:06 19 19 0 0 19.0000 NULL ENUM('2008-08-12 20:24:36','2008-08-12 20:55:57','...
puroparty.wp_7_posts.post_content_filtered     0 0 18 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_7_posts.post_parent -1218578052 17 1 11 6 0 -67698773.4444 279129225.1658 ENUM('-1218578052','0','3','6','10','17') NOT NULL
puroparty.wp_7_posts.guid   http://puroparty.com/ppblogs/index/files/2008/08/t... 0 69 2 0 55.0000 NULL ENUM('','http://puroparty.com/ppblogs/index/?p=17'...
puroparty.wp_7_posts.menu_order 0 0 1 1 18 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.wp_7_posts.post_type attachment post 4 10 0 0 9.0000 NULL ENUM('attachment','page','post') NOT NULL
puroparty.wp_7_posts.post_mime_type   image/jpeg 0 10 3 0 8.3333 NULL ENUM('','image/jpeg') NOT NULL
puroparty.wp_7_posts.comment_count 1 1 1 1 17 0 0.0556 0.2291 ENUM('0','1') NOT NULL


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