> that will display a row number when outputting results? Is this for your schema, or a 'general-could-be-anything' schema? If your own, any reason why you don't use the rowid or _rowid_ columns? They provide a unique reference for each row in a table.
Thanks, Chris On Wed, Oct 31, 2018 at 2:54 PM David Fletcher <da...@phase92.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users