Hello!

$ sqlite3
SQLite version 3.6.20

sqlite> create table test (id INTEGER PRIMARY KEY, a text);
sqlite> insert into test (a) values (1);
sqlite> create view view_test as select rowid,* from test;
sqlite> .header on
sqlite> select * from view_test;
id|id:1|a
1|1|1


Best regards, Alexey Pechnikov.
http://pechnikov.tel/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to