Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 18, 2024 at 10:33 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `lyrics` PROCEDURE ANALYSE();
Rows: 7
| Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
|---|---|---|---|---|---|---|---|---|---|
| puroparty.lyrics.id | 1 | 1511793808 | 1 | 10 | 0 | 0 | 48111183.7438 | 9798401.3426 | INT(10) UNSIGNED NOT NULL |
| puroparty.lyrics.title | Root Android | תקליטן ×œ×—×ª×•× ×•×ª | 2 | 50 | 2128 | 0 | 17.8974 | NULL | VARCHAR(50) NOT NULL |
| puroparty.lyrics.artist | Manuel Esperón | תקליטן ×œ×—×ª×•× ×•×ª | 2 | 50 | 2670 | 0 | 17.5478 | NULL | VARCHAR(50) NOT NULL |
| puroparty.lyrics.album | 09:13:51 | Viene del alma | 3 | 28 | 55860 | 0 | 0.0103 | NULL | ENUM('','09:13:51','360 Degrees','95/08 Exitos','A... |
| puroparty.lyrics.words | Ay corazon, corazon, corazon, que si no me avisas... | ¿Quién será \r\nla que me quiera a mí? \r\n¿quién será... | 3 | 12398 | 2123 | 0 | 697.5189 | NULL | TEXT NOT NULL |
| puroparty.lyrics.extras | 1 | 0 | 3 | 3678 | 0 | 0.9343 | NULL | ENUM('','1\r\n','1') NOT NULL | |
| puroparty.lyrics.file | reik-un_dia_mas.jpg | 0 | 36 | 55895 | 0 | 0.0026 | NULL | ENUM('','09:13:51','enrique_iglesias-9508_exitos.j... |