Well done, you have answered the man's question.
Joe Wilson wrote:
--- John Stanton <[EMAIL PROTECTED]> wrote:
Try looking at the SORT opcode. You can track it through the Sqlite source.
OP_Sort doesn't sort any longer.
It just does a rewind on the cursor.
/* Opcode: Sort P1 P2 *
**
**
--- John Stanton <[EMAIL PROTECTED]> wrote:
> Try looking at the SORT opcode. You can track it through the Sqlite source.
OP_Sort doesn't sort any longer.
It just does a rewind on the cursor.
/* Opcode: Sort P1 P2 *
**
** This opcode does exactly the same thing as OP_Rewind except that
** it in
B V, Phanisekhar wrote:
Assume I have an albumtable:
create table albumtable (albumid INTEGER PRIMARY KEY, album BLOB);
Now I do a query to return the entire albums in the albumtable table in
alphabetical order:
The instructions for the above query are given below:
explain select
On Wed, 2007-07-18 at 16:03 +0530, B V, Phanisekhar wrote:
> Assume I have an albumtable:
>
> create table albumtable (albumid INTEGER PRIMARY KEY, album BLOB);
>
>
>
> Now I do a query to return the entire albums in the albumtable table in
> alphabetical order:
>
>
>
> The instructions fo
Assume I have an albumtable:
create table albumtable (albumid INTEGER PRIMARY KEY, album BLOB);
Now I do a query to return the entire albums in the albumtable table in
alphabetical order:
The instructions for the above query are given below:
explain select album from albumtable order b
5 matches
Mail list logo