I have an index, and I need to find the row in the table with that index in SQLite.
Example:
Example:
Index= 1
Table:
ID-Name
aa1 John
aa2 Mark <-- I need this row
aa3 Lucy
aa4 Jim
Which is the right choice I can use to solve the problem?
Generally, to get specific rows, you can always request them via rowid, for example
< /p>
SELECT name FROM UnknownTable WHERE rowid = 1;
However, there are some atypical situations that will rule out this situation. You really want to be on rowids Read to make sure your table can do what you want.
I have an index, and I need to find the rows in the table with that index in SQLite .
Example:
Index = 1
Table:
ID-Name
aa1 John
aa2 Mark <-- I need this row
aa3 Lucy
aa4 Jim
Which is the right choice I can use to solve the problem?
Usually, to get specific rows, you can always request them via rowid, such as
SELECT name FROM UnknownTable WHERE rowid = 1;
However, there are some atypical situations that will rule out this situation. You really want to read on rowids to make sure your table can do what you want Acting.