Re: [GENERAL] How to express categorized items in relational tables

On Fri, 14 May 1999, Chris Bitmead wrote:

>
> I think you want something like...
> INSERT INTO child(foo,bar,baz,category) SELECT 'foo1', 'bar1', 'baz1,
> oid FROM category WHERE category.name = 'CategoryFoo';

YES!!! That's exactly what I looked for. :-)

Thank you, thank you so much.

>
> I'm not sure. Is that what you mean?
>
> Doo Suk Yang wrote:
>
> > Thank you for your answer. It is going to be working.
> >
> > BTW, when inserting a parents category I had to go through two steps;
> > selecting category of parents and inserting new title and selected
> > category. Of course I'm using Perl and the above two steps are not  great
> > matter. But still I'm curious is it possible to write an SQL statement to
> > do it.
> >
> > ===============================================================================
> > Science is the game we play with God to find out what his rules are.
> > -------------------------------------------------------------------------------
> > Doo Suk Yang
> > Research Scientist                              Voice: 82-42-866-2222
> > LG Chemical Ltd. Research Park
> > Biotech Research Institute I                    FAX:   82-42-861-2566
> > -------------------------------------------------------------------------------
> > A fool hath no delight in understanding, but that his heart may discover itself.
> > (Proverbs 18:2)
> > ===============================================================================
>

===============================================================================
Science is the game we play with God to find out what his rules are.
-------------------------------------------------------------------------------
Doo Suk Yang
Research Scientist                              Voice: 82-42-866-2222
LG Chemical Ltd. Research Park
Biotech Research Institute I                    FAX:   82-42-861-2566
-------------------------------------------------------------------------------
A fool hath no delight in understanding, but that his heart may discover itself.
(Proverbs 18:2)
===============================================================================