Simple query working in SQL but not in Sqlite3 in python

Question

Below is the sql query that is working fine:


SELECT * FROM contracts.wires.monthly_data

But it is not working in python


import sqlite3 
connection = sqlite3.connect("contractsdbro") 
print(connection) 
crsr = connection.cursor() 
crsr.execute("SELECT * FROM contracts.wires.monthly_data")
ans= crsr.fetchall()

Error:

 sqlite3.OperationalError: near ".": syntax error

@Satya : Just tried that ( "SELECT transaction_id, ag_amount FROM contracts.wires.monthly_data" working fine in sql ) ; still getting the same error in python. — Anand KC
– Anand KC, Commented Aug 25, 2019 at 3:37
@Satya: contracts.wires.monthly_data is working fine when I run in SQL, so I think it should be contract is SchemaName and wire is TableName , so not sure what is third component. (not really an sql expert) — Anand KC
– Anand KC, Commented Aug 25, 2019 at 3:46
@Satya : think contracts is the database, wires is the schemaname and monthly_data is the tablename — Anand KC
– Anand KC, Commented Aug 25, 2019 at 3:50

Diego Torres Milano · Accepted Answer · 2019-08-25 07:30:28Z

1

As you can see in

the valid syntax is schema-name.table-name (you have an extra component).

You haven't provided enough information, but just guessing

crsr.execute("SELECT * FROM monthly_data")

should work.

You can use sqlite3 command-line tool to explore your database.

edited Aug 25, 2019 at 7:30

answered Aug 25, 2019 at 3:39

Diego Torres Milano

69.9k9 gold badges116 silver badges145 bronze badges

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

9 Comments

Tim Biegeleisen Over a year ago

You might want to also include the corrected code to make this a complete answer.

Anand KC Over a year ago

@Diego : contracts.wires.monthly_data is working fine in SQL , so can you tell what is its equivalent in slqite3 ?

Anand KC Over a year ago

@TimBiegeleisen : think contracts is the database, wires is the schemaname and monthly_data is the tablename

GIS-Jonathan Over a year ago

@AnandKC - there's no schema names in SQLite unless you attach databases. If you're not attaching databases and only have one database you don't need anything other than select * from monthly_data.

Anand KC Over a year ago

@GIS-Jonathan : Thanks, I have multiple databases , in that case what should be my command

|

Collectives™ on Stack Overflow

Simple query working in SQL but not in Sqlite3 in python

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest