You would want 2 & 3.
You should create 3 tables, one for products, one for categories and one
to relate the two. You should only store ID numbers that relate to
products and categories.
On Thursday, November 7, 2002, at 01:51 PM, Doug Coning wrote:
Hi everyone,
I'd like to know how you would
Third choice, definitely. And aren't you glad your data is sufficiently
normalized that this is a no-brainer!
Cheers - Miles Thompson
At 12:51 PM 11/7/2002 -0600, Doug Coning wrote:
Hi everyone,
I'd like to know how you would set up the following:
I've set up a MySQL database with 600 products
You have to create a table:
CREATE TABLE product_categ (
FK_productID ,
FK_categID
)
and list all relationships "productID belongs to categID"
Ignatius
- Original Message -
From: "Doug Coning" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: T
I am.
Jord
On Tuesday 27 March 2001 14:06, you wrote:
> Why don't you just store the file names in a db?
>
> iets much easyer
>
> > Hi,
> > I want to keep filenames of different kinds of media(real sudio, qt, mp3)
>
> for
>
> > articles in a db table. Would it be best to store each kind of media
Why don't you just store the file names in a db?
iets much easyer
> Hi,
> I want to keep filenames of different kinds of media(real sudio, qt, mp3)
for
> articles in a db table. Would it be best to store each kind of media in a
> different table like one table for real audio, one for quicktime
