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

SQL-query
SQL-query: 
SELECT *
FROM `artists`
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.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...


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