It's probably much faster to do this in perl, since the use of @row
means MySQL can't use its query cache.
--
Jamie McCarthy
http://mccarthy.vg/
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PR
Selon Michael Stassen <[EMAIL PROTECTED]>:
> Kapoor, Nishikant wrote:
>
> > [Sorry for cross-posting.]
> >
> > This is in continuation with the above mentioned subject - I am trying to
> > find the 'display data order' for the returned resultset. The following
> > thread very well answers my
Kapoor, Nishikant wrote:
> [Sorry for cross-posting.]
>
> This is in continuation with the above mentioned subject - I am trying to
> find the 'display data order' for the returned resultset. The following
> thread very well answers my question:
>
> http://lists.mysql.com/mysql/185626
>
> a) SET
Selon "Kapoor, Nishikant" <[EMAIL PROTECTED]>:
>
> > -Original Message-
> > > This is in continuation with the above mentioned subject -
> > I am trying to
> > > find the 'display data order' for the returned resultset.
> > The following
> > > thread very well answers my question:
> > >
>
> -Original Message-
> > This is in continuation with the above mentioned subject -
> I am trying to
> > find the 'display data order' for the returned resultset.
> The following
> > thread very well answers my question:
> >
> > http://lists.mysql.com/mysql/185626
> >
> > a) SET @row=0;
Selon "Kapoor, Nishikant" <[EMAIL PROTECTED]>:
> [Sorry for cross-posting.]
>
> This is in continuation with the above mentioned subject - I am trying to
> find the 'display data order' for the returned resultset. The following
> thread very well answers my question:
>
> http://lists.mysql.com/my
[Sorry for cross-posting.]
This is in continuation with the above mentioned subject - I am trying to find
the 'display data order' for the returned resultset. The following thread very
well answers my question:
http://lists.mysql.com/mysql/185626
a) SET @row=0;
b) SELECT (@row:[EMAIL PROTECTE
hi,
the position of a record depend on the sort order you choose in your queries
(generally order by) and the execution plan of them.
this execution plan depends on data, indexes, and the query itself. So what you
call order is candidate to changing between two selects.
the method shown with @row
From: "Ed Reed"
> Is there way to return the ordinal position of a value within a table?
>
> Let's say I have a table of phone numbers. Over time the table has had
additions and deletions. The table has an autonumber ID field. If I sort by
the ID field I'd like to know what position the number '55
In the last episode (Jun 17), Ed Reed said:
> Is there way to return the ordinal position of a value within a table?
>
> Let's say I have a table of phone numbers. Over time the table has
> had additions and deletions. The table has an autonumber ID field. If
> I sort by the ID field I'd like to
Is there way to return the ordinal position of a value within a table?
Let's say I have a table of phone numbers. Over time the table has had
additions and deletions. The table has an autonumber ID field. If I sort by the
ID field I'd like to know what position the number '555-1212' is in the t
11 matches
Mail list logo
