Re: Relate, join, add row to table or what?
Posted by:
Rick James
Date: September 30, 2013 07:29PM
Why have "chapters"? Why model it after physical books? Why not 'search' for "mornay" and get everyone's recipe for that? I would get rid of the first few tables. Then `recipe` would have `creator_id`, not chapter and page.
But, maybe you prefer the "book" paradigm.
JOIN means exists in both tables.
UNION means exists in either table.
> `incredents_id` int(11) DEFAULT '0',
Probably over-normalized. And you probably wanted NOT NULL.
I would love to see a video of a 'Drunken shrimp' swimming around.
Subject
Written By
Posted
September 28, 2013 02:38PM
Re: Relate, join, add row to table or what?
September 30, 2013 07:29PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.