In your situation (or any situation, IMHO),
multi-value fields defeat the purpose of good database
design.
I think you are on the right track if you are willing
to tolerate a little redundancy for the sake of
simplicity (as a one-to-many relationship). If you
really want to structure it as a many
--- Steven Gearhart <[EMAIL PROTECTED]> wrote:
> The easiest way to add a column is to get somebody
> else to do it.
>
> Seriously, Use the "ALTER TABLE TableName ADD COLUMN
> Company_id INT UNSIGNED
> NULL" command.
Yes. But also, the company_id field probably should be
reset 'not null' AFTER t
