Using python3 and connected to sqlite3 I want to display tables that are in my database, "." in ".tables" keeps giving error and "\" is not helpful [duplicate]

Question

import sqlite3
connection = sqlite3.connect("vsearchlogDB.db")
print("Opened database successfully")  
cursor = connection.cursor()
_SQL = """.tables"""
cursor.execute(_SQL)
print(cursor.fetchall())

Output

>>>python3 dbconnect.py 
Opened database successfully
Traceback (most recent call last):
File "/home/amrit/Documents/webapp/dbconnect.py", line 6, in <module>
cursor.execute(_SQL)
sqlite3.OperationalError: near ".": syntax error

looaka · Accepted Answer · 2021-06-21 09:13:00Z

0

You need to remove the "." from _sql because you are executing a sql command which does not accept "."

answered Jun 21, 2021 at 9:13

looaka

186 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using python3 and connected to sqlite3 I want to display tables that are in my database, "." in ".tables" keeps giving error and "\" is not helpful [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related