MySQL Forums
Forum List  »  Partitioning

How to get Datablock only with ID
Posted by: Josef Oberstadt
Date: March 06, 2018 01:03AM

I get an ID from a table.
Now I will get then nummer of this data in a new query.

I need the number for implement this in my lazyloading.
I use the limit statement.

for excample:
I get the ID from an adresse
Then I start a query with order by name on the adressetable
From this query I will get the position of the ID, in the selection with the order by name.

So I can integrate it in my limit process

Options: ReplyQuote

Written By
How to get Datablock only with ID
March 06, 2018 01:03AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.