Re: [SQL] INSERT and SELECT

>
> Stuart Rison <rison(at)biochemistry(dot)ucl(dot)ac(dot)uk> writes:
> > INSERT INTO table VALUES SELECT oid, 'test' FROM membre WHERE
> > email=3D"toto(at)toto(dot)com";
> I've tried it, but it doesn't work too ("paser error near or at select"),
> even if I replace " by '.

Because VALUES and SELECT are mutually exclusive at that
point.

Just do INSERT INTO table SELECT ...

or INSERT INTO TABLE (attrib, ...) SELECT ...

and the parser should be happy.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#========================================= wieck(at)debis(dot)com (Jan Wieck) #