|
|
Posted by Beauregard T. Shagnasty on 05/23/05 05:58
Ian wrote:
> I have a number of very simple MySQL tables with identical
> structure as follows:
Since your tables are identical, I would use just one table with an
extra field for DIRECTORY. It would contain values "White", "Pigot" etc.
(No harping about 3NF, folks. This should do for the poster.)
Found this after scrolling for several meters...
> So, what I was wondering is would it be better to put them all in
> the same table and add the fields DIRECTORY and YEAR. The only
> problem I can see with that is that the name and year of the
> directory will occupy as much space as the other 4 fields put
> together so seems like it will waste a lot of space, unless I use a
> token to represent the directory name. Basically, as a beginner,
> would appreciate any advice from those with more experience of this
> kind of thing.
Your samples don't have YEAR. What's that about? If you need it, add it.
--
-bts
-This space intentionally left blank.
Navigation:
[Reply to this message]
|