Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 20, 2024 at 05:44 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `pics` 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.pics.month | 00 | 12 | 2 | 2 | 4 | 0 | 1.9892 | NULL | ENUM('','00','01','02','03','04','05','06','07','0... |
| puroparty.pics.day | 00 | sa | 2 | 2 | 4 | 0 | 1.9892 | NULL | ENUM('','00','01','02','03','04','05','06','07','0... |
| puroparty.pics.year | 2002 | 2008 | 4 | 4 | 2 | 0 | 1999.1077 | 103.8676 | ENUM('0','2002','2003','2004','2005','2006','2007'... |
| puroparty.pics.link1 | <A \r\nHREF=javascript:popUp2('http://www.puroparty.... | <A HREF=javascript:popUp2(http://www.puroparty.us/... | 231 | 401 | 2 | 0 | 295.6581 | NULL | TEXT NOT NULL |
| puroparty.pics.entertainer | vital | 0 | 71 | 311 | 0 | 11.3190 | NULL | ENUM('','adalberto santaigo','adalberto, latin bre... | |
| puroparty.pics.eventname | 23rd annual festival chicano | ttma kickoff party | 3 | 50 | 306 | 0 | 11.6057 | NULL | ENUM('','23rd annual festival chicano','24th annua... |
| puroparty.pics.venue | 610 arena | zazz | 4 | 32 | 24 | 0 | 14.9341 | NULL | ENUM('','610 arena','almeda mall','apollo club','a... |
| puroparty.pics.city | alice | vinton, la | 4 | 15 | 3 | 0 | 7.6312 | NULL | ENUM('','alice','alvin','angleton','austin','bayto... |
| puroparty.pics.weekday | \r | wed | 1 | 9 | 4 | 0 | 3.7941 | NULL | ENUM('\r','','aug','feb\r','fri\r','fri','friday','mo... |