[ Charset ISO-8859-1 unsupported, converting... ]
>
> > > > He does ask a legitimate question though. If you are
> > going to have a
> > > > LIMIT feature (which of course is not pure SQL), there
> > seems no reason
> > > > you shouldn't be able to insert the result into a table.
> > >
> > >
> > > He does ask a legitimate question though. If you are
> going to have a
> > > LIMIT feature (which of course is not pure SQL), there
> seems no reason
> > > you shouldn't be able to insert the result into a table.
> >
> >
>
> This is an interesting idea. We don't allow ORDER BY in
> I
Hello,
just my $0.02...
If I do
insert into x
select * from y limit 10;
I will get all of rows in x inserted, not just 10...
I already wrote about this... But did not get any useful reply.
> This is an interesting idea. We don't allow ORDER BY in INSERT INTO ...
> SELECT because it doesn't m
>
> Well, If I'm reading the spec correctly,
> INSERT INTO references a query expression
> which doesn't include ORDER BY as an option, so this
> is even less SQL since we're actually not just changing
> it to allow our non-standard bit, but we're changing
> a piece that is explicitly not allowe
