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

SQL-query
SQL-query: 
SELECT *
FROM `jos_weblinks`
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_weblinks.id 1 6 1 1 0 0 3.5000 1.7078 ENUM('1','2','3','4','5','6') NOT NULL
puroparty.jos_weblinks.catid 2 2 1 1 0 0 2.0000 0.0000 ENUM('2') NOT NULL
puroparty.jos_weblinks.sid 0 0 1 1 6 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.jos_weblinks.title Joomla! php.net 5 25 0 0 12.8333 NULL ENUM('Joomla!','Joomla! - Forums','MySQL','Ohloh T...
puroparty.jos_weblinks.alias joomla php 3 24 0 0 11.3333 NULL ENUM('joomla','joomla-forums','mysql','ohloh-track...
puroparty.jos_weblinks.url http://forum.joomla.org http://www.php.net 18 32 0 0 24.3333 NULL ENUM('http://forum.joomla.org','http://www.joomla....
puroparty.jos_weblinks.description Home of Joomla! The language that Joomla! is developed in 11 118 0 0 38.1667 NULL ENUM('Home of Joomla!','Home of OSM','Joomla! Foru...
puroparty.jos_weblinks.date 2004-07-07 10:18:31 2007-07-19 09:28:31 19 19 0 0 19.0000 NULL ENUM('2004-07-07 10:18:31','2004-07-07 11:33:24','...
puroparty.jos_weblinks.hits 1 11 1 2 0 0 4.3333 3.4480 ENUM('1','3','4','6','11') NOT NULL
puroparty.jos_weblinks.published 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL
puroparty.jos_weblinks.checked_out 0 0 1 1 6 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.jos_weblinks.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_weblinks.ordering 1 6 1 1 0 0 3.5000 1.7078 ENUM('1','2','3','4','5','6') NOT NULL
puroparty.jos_weblinks.archived 0 0 1 1 6 0 0.0000 0.0000 ENUM('0') NOT NULL
puroparty.jos_weblinks.approved 1 1 1 1 0 0 1.0000 0.0000 ENUM('1') NOT NULL
puroparty.jos_weblinks.params target=0\n\n target=0 8 10 2 0 5.6667 NULL ENUM('','target=0\n\n','target=0') NOT NULL


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