Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 27, 2024 at 12:46 AM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `radio` 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.radio.id | 1 | 63 | 1 | 2 | 0 | 0 | 32.0000 | 18.1842 | TINYINT(2) UNSIGNED NOT NULL |
puroparty.radio.amfm | AM | FM | 2 | 2 | 0 | 0 | 2.0000 | NULL | ENUM('AM','FM') NOT NULL |
puroparty.radio.letters | KANI | KYST | 4 | 4 | 0 | 0 | 4.0000 | NULL | ENUM('KANI','KBME','KBXX','KCOH','KEYH','KFCC','KF... |
puroparty.radio.frequency | 100.3 | 99.1 | 3 | 5 | 0 | 0 | 4.0635 | NULL | ENUM('100.3','100.7','101.1','101.5','1010','102.1... |
puroparty.radio.format | '80s rock. | Vietnamese. | 6 | 45 | 0 | 0 | 17.7143 | NULL | ENUM(' \'80s rock.',' Adult contemporary rock.',' ... |
puroparty.radio.website | http://http://www.khjz.com/ | http://www.xoradio.com | 19 | 30 | 14 | 0 | 18.7778 | NULL | ENUM('','http://http://www.khjz.com/','http://kqbu... |
puroparty.radio.owner | 0 | 0 | 63 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
puroparty.radio.city | Houston | Houston | 7 | 7 | 0 | 0 | 7.0000 | NULL | ENUM('Houston') NOT NULL |
puroparty.radio.state | Texas\r | Texas\r | 6 | 6 | 0 | 0 | 6.0000 | NULL | ENUM('Texas\r') NOT NULL |