mardi 24 novembre 2015

Sqlite error loading sql file

I am getting the error

 Error: near line 15: near "s": syntax error

I am not sure what I am doing wrong. I have read through the DELETE documentation in sqlite but can't seem to figure out what I am doing wrong

DELETE s.*, c.*
FROM student s, cameras c, bookstore b
WHERE c.name = b.kname
AND b.mno = s.no
AND s.type = 'jumbo';

I am tried removing the .* also but seems to be getting the same error. Any help would be appreciated.

Aucun commentaire:

Enregistrer un commentaire