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)