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

SQL-query
SQL-query: 
SELECT *
FROM `jos_newsfeeds`
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.jos_newsfeeds.catid 4 7 1 1 0 0 5.5000 1.0000 ENUM('4','5','6','7') NOT NULL
puroparty.jos_newsfeeds.id 1 8 1 1 0 0 4.5000 2.2913 ENUM('1','2','3','4','5','6','7','8') NOT NULL
puroparty.jos_newsfeeds.name Business News Web Developer News 11 28 0 0 21.1250 NULL ENUM('Business News','Joomla! - Community News','J...
puroparty.jos_newsfeeds.alias business-news web-developer-news 11 28 0 0 20.5000 NULL ENUM('business-news','joomla-community-news','joom...
puroparty.jos_newsfeeds.link http://headlines.internet.com/internetnews/bus-new... http://www.joomla.org/index.php?option=com_rss_xtd... 41 112 0 0 62.2500 NULL ENUM('http://headlines.internet.com/internetnews/b...
puroparty.jos_newsfeeds.filename     0 0 8 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.jos_newsfeeds.published 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL
puroparty.jos_newsfeeds.numarticles 3 5 1 1 0 0 3.5000 0.8660 ENUM('3','5') NOT NULL
puroparty.jos_newsfeeds.cache_time 3600 3600 4 4 0 0 3600.0000 0.0000 ENUM('3600') NOT NULL
puroparty.jos_newsfeeds.checked_out 0 0 1 1 8 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.jos_newsfeeds.checked_out_time 0000-00-00 00:00:00 0000-00-00 00:00:00 19 19 0 0 19.0000 NULL ENUM('0000-00-00 00:00:00') NOT NULL
puroparty.jos_newsfeeds.ordering 1 9 1 1 0 0 4.7500 2.6339 ENUM('1','2','3','4','5','6','8','9') NOT NULL
puroparty.jos_newsfeeds.rtl 0 0 1 1 8 0 0.0000 0.0000 ENUM('0') NOT NULL


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