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

SQL-query
SQL-query: 
SELECT *
FROM `wp_8_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_8_posts.ID 1 11 1 2 0 0 6.3000 3.1639 ENUM('1','2','4','5','6','7','8','9','10','11') NO...
puroparty.wp_8_posts.post_author 6 6 1 1 0 0 6.0000 0.0000 ENUM('6') NOT NULL
puroparty.wp_8_posts.post_date 2008-08-14 13:33:12 2008-09-10 02:56:40 19 19 0 0 19.0000 NULL ENUM('2008-08-14 13:33:12','2008-08-19 23:59:22','...
puroparty.wp_8_posts.post_date_gmt 2008-08-14 18:33:12 2008-09-10 07:56:40 19 19 0 0 19.0000 NULL ENUM('2008-08-14 18:33:12','2008-08-20 04:59:22','...
puroparty.wp_8_posts.post_content <p class="MsoNormal" style="margin: 0in 0in 0pt"><... Welcome to <a href="http://puroparty.com/ppblogs/"... 34 6096 1 0 1259.1000 NULL TEXT NOT NULL
puroparty.wp_8_posts.post_title About Register to Vote 5 105 0 0 51.7000 NULL ENUM('About','AVIZO Singer Chris Q to sing Nationa...
puroparty.wp_8_posts.post_category 0 0 1 1 10 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.wp_8_posts.post_excerpt   Party on the Plaza is coming this fall 0 38 9 0 3.8000 NULL ENUM('','Party on the Plaza is coming this fall') ...
puroparty.wp_8_posts.post_status inherit publish 7 7 0 0 7.0000 NULL ENUM('inherit','publish') NOT NULL
puroparty.wp_8_posts.comment_status open open 4 4 0 0 4.0000 NULL ENUM('open') NOT NULL
puroparty.wp_8_posts.ping_status open open 4 4 0 0 4.0000 NULL ENUM('open') NOT NULL
puroparty.wp_8_posts.post_password     0 0 10 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_8_posts.post_name about register-to-vote 5 104 0 0 50.5000 NULL ENUM('about','avizo-singer-chris-q-to-sing-nationa...
puroparty.wp_8_posts.to_ping     0 0 10 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_8_posts.pinged     0 0 10 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_8_posts.post_modified 2008-08-14 13:33:12 2008-09-10 02:56:40 19 19 0 0 19.0000 NULL ENUM('2008-08-14 13:33:12','2008-08-19 23:59:22','...
puroparty.wp_8_posts.post_modified_gmt 2008-08-14 18:33:12 2008-09-10 07:56:40 19 19 0 0 19.0000 NULL ENUM('2008-08-14 18:33:12','2008-08-20 04:59:22','...
puroparty.wp_8_posts.post_content_filtered     0 0 10 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.wp_8_posts.post_parent 0 0 1 1 10 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.wp_8_posts.guid   http://puroparty.com/ppblogs/jump/files/2008/08/po... 0 60 2 0 32.8000 NULL ENUM('','http://puroparty.com/ppblogs/jump/?p=10',...
puroparty.wp_8_posts.menu_order 0 0 1 1 10 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.wp_8_posts.post_type attachment post 4 10 0 0 4.6000 NULL ENUM('attachment','page','post') NOT NULL
puroparty.wp_8_posts.post_mime_type   image/png 0 9 9 0 0.9000 NULL ENUM('','image/png') NOT NULL
puroparty.wp_8_posts.comment_count 2 3 1 1 8 0 0.5000 1.0247 ENUM('0','2','3') NOT NULL


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