Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 23, 2024 at 07:09 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `mega101` PROCEDURE ANALYSE();
Rows: 9
| 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.... |