dimanche 14 février 2016

sqlite: multiple where clause syntax: where s="somestring" and where i=0;

What mistake am I making?

$ sqlite3 test.db
SQLite version 3.8.5 2014-08-15 22:37:57
Enter ".help" for usage hints.
sqlite> create table t (s text not null, i integer);
sqlite> select * from t where s="somestring"; /* works */;
sqlite> select * from t where i=0; /* works */;
sqlite> select * from t where s="somestring" and where i=0;
Error: near "where": syntax error

Aucun commentaire:

Enregistrer un commentaire