On Sat, 23 Mar 2019 12:57:55 +0100 (CET) Eric <[email protected]> wrote: > On Fri, 22 Mar 2019 16:34:20 -0500, Peng Yu <[email protected]> > 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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users --- --- Eduardo Morras <[email protected]> _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
