lundi 2 mars 2015

Odd no such column error SQLite3

I'm only beginning to learn SQL with SQLite3 so this question probably has a clear answer, which I just can't think of. I have a table called Books, which has the columns: name, author and price. When I type e.g. select name, price from Books where author = "A"; in sqlite3, it works just fine. However, when I make a .sql file with the following:


SELECT name, price FROM Books WHERE author = "A";


and read the file in the same database, it reads 'Error: near line 1: no such column: "A"'


Any ideas?


Aucun commentaire:

Enregistrer un commentaire