andard in this case doesn't guarantee that
> outer select will return rows in the same order that were enforced in
> inner select by "order by", does it?
>
> Pavel
>
> On Wed, Jun 10, 2009 at 11:15 AM, Rand Huck wrote:
> > Just out of curiosity, where in the
Just out of curiosity, where in the syntax documentation does it mention
"selected from"?
On Wed, Jun 10, 2009 at 10:57 AM, Igor Tandetnik wrote:
> Rand Huck wrote:
> > In addition to what was already said, if you absolutely to omit the
> > 'name' from the fina
In addition to what was already said, if you absolutely to omit the 'name'
from the final result set, you should be able to put the result of the union
in a temporary table.
CREATE TEMPORARY TABLE `tmp` (`id`, `url`, `selected`, `name`);
INSERT INTO `tmp` (
SELECT id, url, selected, name FROM d
on. :P I need a beer.
On Fri, Mar 13, 2009 at 9:12 PM, Igor Tandetnik wrote:
> "Rand Huck" wrote in
> message
> news:d232e14b0903131800j53e59f56ic8e19b1d94bd7...@mail.gmail.com
> > When I execute this, SQLite gives me a very useless error code: -1
> > with no add
Sorry, that was the result of my genericizing the code. The code I have does
not have the trailing comma.
On Fri, Mar 13, 2009 at 9:03 PM, Igor Tandetnik wrote:
> "Rand Huck" wrote in
> message
> news:d232e14b0903131800j53e59f56ic8e19b1d94bd7...@mail.gmail.com
> > CREA
I am refactoring a table for an Adobe AIR application a little bit and am
calling the following statements:
CREATE TEMPORARY TABLE `tbl_backup` (
`id` integer,
`title`varchar(255),
`body`text,
`status`varchar(16)
);
INSERT INTO
6 matches
Mail list logo