Why am I getting a syntax error with the following line?
statement = self.sql.execute("DESCRIBE TEST")
I get the following error:
sqlite3.OperationalError: near "DESCRIBE": syntax error
asked Jun 29, 2012 at 7:14
Sheldon
10.2k22 gold badges64 silver badges102 bronze badges
-
3Possible duplicate: stackoverflow.com/questions/3330435/…Shubham– Shubham2012年06月29日 07:17:11 +00:00Commented Jun 29, 2012 at 7:17
1 Answer 1
DESCRIBE is not a valid sqlite3 command, use .schema TEST
answered Jun 29, 2012 at 7:16
Uku Loskit
42.2k9 gold badges97 silver badges98 bronze badges
Sign up to request clarification or add additional context in comments.
2 Comments
Guiste
If I do statement = self.sql.execute(".schema TEST") I get: "OperationalError: near ".": syntax error"
Uku Loskit
that only works on the sqlite shell I believe
default