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

SQL-query
SQL-query: 
SELECT *
FROM `mega101`
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.mega101.rank 1 10 1 2 0 0 5.5000 2.8723 ENUM('1','2','3','4','5','6','7','8','9','10') NOT...
puroparty.mega101.song Angel y Khriz - Ven Bailalo Xtreme - Te Extrano 12 46 0 0 28.3000 NULL ENUM('Angel y Khriz - Ven Bailalo','Aventura & Don...
puroparty.mega101.playstw 37 66 2 2 0 0 2.0000 NULL ENUM('37','38','44','46','47','50','59','62','63',...
puroparty.mega101.playslw 25 74 2 2 0 0 2.0000 NULL ENUM('25','31','36','44','60','61','64','70','73',...
puroparty.mega101.video     0 0 10 0 0.0000 NULL CHAR(0) NOT NULL
puroparty.mega101.audio   <OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444... 0 587 9 0 58.7000 NULL ENUM('','<OBJECT classid="clsid:D27CDB6E-AE6D-11cf...
puroparty.mega101.lyrics - <a href=http://www.puroparty.com/lyricdetail.php?i... 1 79 0 0 8.8000 NULL ENUM('-','<a href=http://www.puroparty.com/lyricde...
puroparty.mega101.label Columbia SGZ 3 22 0 0 13.0000 NULL ENUM('Columbia','El Cartel/Interscope','EMI Latin'...
puroparty.mega101.pic angelykhriz.jpg xtreme.jpg 9 15 0 0 12.9000 NULL ENUM('angelykhriz.jpg','aventura.jpg','chrisbrown....


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