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