Miscellany

mysql> describe lgio;
+--------+--------------+------+-----+---------+-------+
| Field  | Type         | Null | Key | Default | Extra |
+--------+--------------+------+-----+---------+-------+
| artist | varchar(20)  | NO   |     |         |       |
| title  | varchar(40)  | NO   |     |         |       |
| album  | varchar(105) | YES  |     | NULL    |       |
| year   | year(4)      | YES  |     | NULL    |       |
| genre  | varchar(10)  | YES  |     | NULL    |       |
| votes  | decimal(5,0) | YES  |     | NULL    |       |
+--------+--------------+------+-----+---------+-------+
6 rows in set (0.00 sec)

mysql> insert into lgio values ('','','','','',1);
Query OK, 1 row affected, 1 warning (0.01 sec)