Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 19, 2024 at 07:50 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `artists` PROCEDURE ANALYSE();
Rows: 20
Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
---|---|---|---|---|---|---|---|---|---|
puroparty.artists.id | 1 | 6 | 1 | 1 | 0 | 0 | 3.5000 | 1.7078 | ENUM('1','2','3','4','5','6') NOT NULL |
puroparty.artists.name | \r\nBaby Jay | Reflejo | 7 | 26 | 0 | 0 | 13.1667 | NULL | ENUM('\r\nBaby Jay','Ambixion','Los Gavilanes de la ... |
puroparty.artists.photo | ambixion/ambixion3.jpg | reflejo/reflejo425x235.jpg | 20 | 33 | 0 | 0 | 24.1667 | NULL | ENUM('ambixion/ambixion3.jpg','babyjay/babyjay1.jp... |
puroparty.artists.photo2 | ambixion/ambixion2.jpg | reflejo/reflejo425x235.jpg | 20 | 34 | 0 | 0 | 24.6667 | NULL | ENUM('ambixion/ambixion2.jpg','babyjay/babyjay2.jp... |
puroparty.artists.photo3 | ambixion/ambixion.jpg | reflejo/reflejo425x235.jpg | 20 | 34 | 0 | 0 | 24.5000 | NULL | ENUM('ambixion/ambixion.jpg','babyjay/babyjay3.jpg... |
puroparty.artists.bio | \r\nBaby Jay, started dancing at the age of 4 and ra... | The Hermanos Cortez group is originally from Denve... | 1410 | 4045 | 1 | 0 | 2334.6667 | NULL | TEXT NOT NULL |
puroparty.artists.message | 0 | 0 | 6 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.artists.ad | <script type="text/javascript"><!--\r\ngoogle_ad_cli... | <script type="text/javascript"><!--\r\ngoogle_ad_cli... | 532 | 532 | 5 | 0 | 88.6667 | NULL | ENUM('','<script type="text/javascript"><!--\r\ngoog... |
puroparty.artists.player | <script src="http://www.puroparty.com/ppjuke.js" t... | <script src="http://www.puroparty.com/ppjuke.js" t... | 3046 | 3211 | 1 | 0 | 2634.3333 | NULL | TEXT NOT NULL |
puroparty.artists.folder | ambixion | reflejo | 7 | 14 | 0 | 0 | 8.8333 | NULL | ENUM('ambixion','babyjay','gavilanes','hermanoscor... |
puroparty.artists.cd1pic | <img src=artists/babyjay/cd1.jpg> | <img src=http://www.puroparty.com/artists/markylee... | 33 | 59 | 4 | 0 | 15.3333 | NULL | ENUM('','<img src=artists/babyjay/cd1.jpg>','<img ... |
puroparty.artists.cd1name | Antojo de Amor | Keepin It Real | 14 | 14 | 4 | 0 | 4.6667 | NULL | ENUM('','Antojo de Amor','Keepin It Real') NOT NUL... |
puroparty.artists.cd2pic | <img src=http://www.puroparty.com/artists/markylee... | <img src=http://www.puroparty.com/artists/markylee... | 59 | 59 | 5 | 0 | 9.8333 | NULL | ENUM('','<img src=http://www.puroparty.com/artists... |
puroparty.artists.cd2name | Dejame Sentir Tu Amor | Dejame Sentir Tu Amor | 21 | 21 | 5 | 0 | 3.5000 | NULL | ENUM('','Dejame Sentir Tu Amor') NOT NULL |
puroparty.artists.cd3pic | 0 | 0 | 6 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.artists.cd3name | 0 | 0 | 6 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.artists.cd4pic | 0 | 0 | 6 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.artists.cd4name | 0 | 0 | 6 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.artists.lyrics | <a href=http://www.puroparty.com/lyricdetail.php?i... | <a href=http://www.puroparty.com/lyricdetail.php?i... | 118 | 118 | 5 | 0 | 19.6667 | NULL | ENUM('','<a href=http://www.puroparty.com/lyricdet... |
puroparty.artists.thumbnail | ambixion_t.jpg | reflejo_t.jpg | 13 | 20 | 0 | 0 | 14.8333 | NULL | ENUM('ambixion_t.jpg','babyjay_t.jpg','gavilanes_t... |