Host: mysql.puroparty.com
Database: puroparty
Generation Time: May 17, 2024 at 08:09 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `email_subscribers_data` PROCEDURE ANALYSE();
Rows: 3
| Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
|---|---|---|---|---|---|---|---|---|---|
| puroparty.email_subscribers_data.subscriberid | 3 | 19165 | 1 | 5 | 0 | 0 | 1154.5764 | 4076.0853 | SMALLINT(5) UNSIGNED NOT NULL |
| puroparty.email_subscribers_data.fieldid | 1 | 10 | 1 | 2 | 0 | 0 | 2.6308 | 1.0349 | ENUM('1','2','3','5','7','8','9','10') NOT NULL |
| puroparty.email_subscribers_data.data | 12318 Hoggard | Zuniga | 1 | 17 | 0 | 0 | 6.2129 | NULL | ENUM('12318 Hoggard','1306 Lemm Rd. 2','21228','2723 Houston Ave.','3 Stoneham Court','36','40','43','60','77009','77373','77477','80104','A','abron','Acevedo','ADELINO','Adriana','Aguilar','Aguillon','aguirre','Aida','AL','alaniz','Albert','alberto','Alderete','Alderink','alexandra','ALFARO','Alfred','alfredo','alma','Almanza','alquicira','Alvarado','alvarez','AMANDA','Amaya','Amy','ana','andrade','angelica','angie','anguiano','Anna','Annabelle','Anne','Annette Marie','Anthony','APOLONIO','araceli','Aranda','arcos','Arismendez','arizola','Arlene','Armando','Armando Jr','Atkinson','Avila','Ayala','Baldemar','barbie','barboza','Barrera','Barrientos','Barron','Bazan','becerra jr','Belinda','Ben','Berlinda','Bernabe','Berrospe','BERTHA','Betty','Bety','BILL','blanca','Boatright','Botello','BRAVO','Brenda','Bridget','Calderon','Canales','Cantu','cardenas','carmelo','carmen','Carranza','CARRASCO','Carrillo','carrion','CASARES','Castillo','Castle Rock','Castro','Catonsville','ceballos','Cecilia','Cedillo','Chavez','chris','Christian','Christina','christy','Cindy','cirilo','CLAUDIA','CO','Coleman','Collazo','Contreras','Cordaway','Covarrubias','Cox','cristobal','cruz','crystal','Cynthia','Daniel','Darabel','David','davila','DEBBIE','deleon','Delgado','Delia','DELLA','Delores','denise','Diana','Dianne','DJ Art','Dolores','Donajih','DORA','DORMA','Duarte','Dustin','Eddie','Elena','Eliza','Elizabeth','elsa','Elva','elvia','Emily','Enriquez','ERLINE RAYOS','Escamilla','Escobedo','Esmeralda','estelle','Esther','ESTRADA','Estrello','Eva','evelin','EVERHART','f','Falcon','Felan','Feliciano','Felix','fernandez','Fernando','FERNANDO JR','flores','francine','francisca','frank','fredy','Fuentes','Gabel','Gabriel','Gail','galaviz','gallegos','Galvan','gamino','GAONA','Garcia','Garica','GARZA','Gatto','gavino','George','georgio','GIL','Gina','Gloria','gomez','Gonzales','Gonzalez','Gracie','greg','Griselda','GUADALUPE','Guajardo','Guerrero','Guevara','gutierrez','Guzman','HALL','Hamilton','hastedt','haydely','HECTOR','Henry','hernandez','Herrada','hinojosa','Holly','Houston','Huerta','huizar','Ileen','Imelda','Infante','Irene','Irma','isabell','Ivy','izadora','j','ja net','Jackie','Janie','Jaramillo','Jaso','Jason','javier','JD','Jen','Jennifer','jesse','jessica','Jessie','Jimenez','Jiminez','Jo Ann','Joan','Joe','JOHN','John R.','johnny','Jonee','Jorge','jose','Jose Angel','Jose Luis','Josh','Joshua','JR.','juan','juar','Juarez','julia','julissa','KENNY','Khoury','kina','KRISTINA','laforce','laguer','lara','LARRY','Laura','layla','leal','LeBourgeois','ledesma','Leisa','LEO','LEVARIO','Leyva','Lily','LIMON','Limones','Linda','Lisa','Liz','Loco','Loera','Logan','lolita','Long','LONGORIA','lopez','Lopez Aranda','LORA','lorena','lorenzo','Loretta','Louisa','Lucia','Lucio','LUCY','Luis','LUNA','Lupe','Lupita','luz','lydia','Lynda','m','macey','Macias','magana','MALDONADO','Marcela','margie','Maria','Maria Elva','Marie','MARIO','Marisela','marlen','Marlene','marry','Marsha','Martha','Martin','Martinez','Mary','MARY JANE','Mary Rose','MARY-JANE','Matt','McCarthy','MD','me','Meadows Place','Melba','MELCHOR','Melinda','Melisa','Melissa','Mendez','MENDOZA','Meyer','Michael','Michael J','MICHELE','Michelle','Mijares','Mireles','Molina','MONA','Monica','monique','Monreal','Montalvo','Montiel','Morado','Moraga','Morales','Moreno','MORIN','muniz','Murillo','Myrna','Najera','Nancy','Nanez','narv','Navarro','nevares','Nico','nicole','Nidia','Noe','nolasco','nora','Norma','Ochoa','Ofelia','Olga','Olivarez','olvera','OMAR','Ontiveros','Oralia','Orellana','ortega','ortiz','oscar','P O Box 1778','P.','padilla','Palacios','PAREDES','Patricia','paulette','Pearl','Pena','Penn','Perales','peralez','Perez','pete','pineda','Poco','Ponce','PORCAYO','Rabago','rachael','rachel','rafael','Ramirez','RAMIRO ROY','Ramon','RAMOS','rangel','Raquel','Ray','Rebeca','rebecca','Renato','RENE','Renteria','Rey','reyes','Reyna','Richard','Riojas','Rios','rita','Rivera','rob','robert','Roberto','robledo','rocha','Rodolfo','Rodrigo','rodriguez','rogelio','ROGER','ROJAS','Rojas-Barrett','Roland','ROMELIA','Romero','romo','Rosalba','Rosales','rosalinda','Rose','Rosemary','ROSSY','roxanne','Roy','Ruben','Rucker','Rudy','Rufina','Ruiz','Russell','S.','saenz','Salazar','salazar jr.','SALINAS','Sanchez','sandra','SanMiguel','santiago','santos','Sara','Selestino','sergio','serna','serrano','Silguero','Silva','Sol','Solis','Sonya','Sonzala','soria','sorola','sosa','Soto','Spears','Spring','Stella','stephanie','STEPHENS','stokes muroski','Suarez','Suarez - Leek','Susan','Susie','Sylvan','sylvia','Tafolla','Talia','Tanya','tapia','taylor','Tellez','TERAN','Teresa','Terryann','Thomas','Thompson','tina','Tomas','Torres','Tovar','TREVINO','Tristan','Turrubiartes','Tx','V','valdez','valerio','valles','Vargas','Vasquez','VELAZQUEZ','Veronica','vianee','VIANNEY','VICENTE','vickie','Victor','Vidaurri','Villa','Villalobos','VILLAREAL','Villarreal','Villegas','Vilma','Virginia','Willie','Yadira','Ybarra','Yenit','Yesenia','Yolanda','Yoli','Yram','Yvonne','zarate','zavala','Zenaida','zuleta','Zuniga') NOT NULL |