Hi all,
Is there a mode in the sqlite shell, or some fancy extension, that will
display a row
number when outputting results? You know, something like this:
sqlite> .row on
sqlite> select * from SomeTable where ... ;
1. a|17|93|...
2. b|212|104|...
I tend to use the sqlite shell for debugging new queries and seeing a row
number would save me from always doing a 'select count(*) from (...
previous select ...)'
command.
Thanks,
David
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
