Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 26, 2024 at 04:23 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `top40vids` PROCEDURE ANALYSE();
Rows: 4
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.top40vids.id | 1 | 10 | 1 | 2 | 0 | 0 | 5.5000 | 2.8723 | ENUM('1','2','3','4','5','6','7','8','9','10') NOT NULL |
puroparty.top40vids.artist | Akon | The Fray | 4 | 17 | 0 | 0 | 8.6000 | NULL | ENUM('Akon','Beyonce','Fergie','Gwen Stefani','Hinder','Jim Jones','Justin Timberlake','Nelly Furtado','The Fray') NOT NULL |
puroparty.top40vids.title | Fergalicious | Wind It Up | 7 | 18 | 0 | 0 | 12.4000 | NULL | ENUM('Fergalicious','How To Save A Life','I Wanna Love You','Irreplacable','Lips Of An Angel','My Love','Say It Right','Smack That','We Fly High','Wind It Up') NOT NULL |
puroparty.top40vids.url | http://75.126.19.45/asx.php?id=33063 | http://videzonn.com/videos/g/gwen_stefani/wind_it_up_115074.asx | 36 | 63 | 0 | 0 | 38.7000 | NULL | ENUM('http://75.126.19.45/asx.php?id=33063','http://75.126.19.45/asx.php?id=33538','http://75.126.19.45/asx.php?id=33626','http://75.126.19.45/asx.php?id=33799','http://75.126.19.45/asx.php?id=33851','http://75.126.19.45/asx.php?id=33857','http://75.126.19.45/asx.php?id=34170','http://75.126.19.45/asx.php?id=34278','http://75.126.19.45/asx.php?id=34329','http://videzonn.com/videos/g/gwen_stefani/wind_it_up_115074.asx') NOT NULL |