On 01/31/2012 04:05 AM, bhaskarReddy wrote:
Hi Friends,
Can any one tell me how to access values of a table column
with its particular row id.
I tried with "select * from ontTable where rowid=2;"
I am getting the output as 1|2|3|XYZ234|4|ABCD123|5.
On Jan 31, 2012, at 10:05 AM, bhaskarReddy wrote:
> Can any one tell me how to access values of a table column with its
> particular row id.
In general, I would suggest that you get the basics straight:
http://www.sqlite.org/books.html
> I tried with "select * from ontTable where rowid=2;"
h
select columnName from ontTable where rowid = 2;
select * gets you all of the columns for the row. select columnName
will just get one column.
Cheers,
Larry
On 31 January 2012 17:05, bhaskarReddy wrote:
>
> Hi Friends,
>
>
> Can any one tell me how to access values of a table colu
Hi Friends,
Can any one tell me how to access values of a table column
with its particular row id.
I tried with "select * from ontTable where rowid=2;"
I am getting the output as 1|2|3|XYZ234|4|ABCD123|5.
Here i want the value
4 matches
Mail list logo