On Sat, 23 Mar 2019 12:57:55 +0100 (CET)
Eric <e...@deptj.eu> wrote:
> On Fri, 22 Mar 2019 16:34:20 -0500, Peng Yu <pengyu...@gmail.com>
> wrote:
> > There are cid's for each table. Is there a way to use "select" with
> > cid's instead of their names? Thanks.
> >
> > $ sqlite3 dbfile <<EOF
> > create table test (id integer primary key, value text);
> > insert into test (id, value) values (1, 'abc');
> > .mode column
> > .headers on
> > select * from pragma_table_info('test');
> > EOF
> > cid name type notnull dflt_value pk
> > ---------- ---------- ---------- ---------- ----------
> > ---------- 0 id integer
> > 0 1 1 value text
> > 0 0
>
> Why on earth would you want to do that?
To write obfuscated code, perhaps for a prize or trojan, etc... development
> Eric
> --
> ms fnd in a lbry
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--- ---
Eduardo Morras <emorr...@yahoo.es>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
