List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:September 24 1999 4:57am
Subject:Re: about tables ...
View as plain text  
On Fri, 1999-09-24 06:24:22 +0200, Bart Zylowski wrote:
> I have just a little question about tables in Mysql.
> Is it better to have more tables with less fields or less tables
> with more fields?

This question isn't really MySQL specific, but you address the broader
field of good (relational) database design in general.

I found some web pages that might be useful:

- Database Tutorials Menu
  <URL: >

- Designing a Database -- Understanding Relational Design
  <URL: >
  <URL: >
  <URL: >

The short answer to your question is:
  Neither many nor few fields per table is good, but the right fields!
  Every table should be about only _one_ subject, and then should hold
  all fields to describe this subject.

Martin Ramsch <m.ramsch@stripped> <URL: >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
about tables ...Bart Zylowski24 Sep
  • Re: about tables ...Martin Ramsch24 Sep
  • Re: about tables ...Bob Kline24 Sep