| MP3Files | ||
| Column | Type | default |
| MP3ID | int | auto increment |
| Genre | varchar(255) | NULL |
| Artist | varchar(255) | NULL |
| Album | varchar(255) | NULL |
| Song Name | varchar(255) | NULL |
| Play Length | varchar(255) | NULL |
... and amazingly never see the problem with this.
2006-12-14
Database Design
Let's say I want a screen that displays a list of MP3s with Genre, Artist, Album, Song Name, Play Length. What would the database table for this look like? Many neophytes would design a table that looked like:
... and amazingly never see the problem with this.
... and amazingly never see the problem with this.
