$ bin/sqlite3
SQLite version 3.6.17
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table t(a integer);
sqlite> select main.t.* from t;
SQL error: near "*": syntax error
sqlite> select main.t.* from main.t;
SQL error: near "*": syntax error
sqlite> select t.* from t;
sqlite> select t.* from main.t;
sqlite> select main.t.* from main.t;
SQL error: near "*": syntax error
sqlite> select main.t.a from main.t;
sqlite> select main.t.a from t;
sqlite> .quit

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to