SQL syntax error when reading data from database

Question

Running the code shown here, I get a SQL syntax error, couldn't find the reason:

startEpoch = 1623331800#july 10 7PM ePOCH
EndEpoch = 1624195800#july 20 7PM ePOCH

query = "SELECT `Machine`,`Epoch`,`Time`,`STATE` FROM MSC where `Epoch`>=" + str(startEpoch) + "and `Epoch`<=" + str(EndEpoch) + ";"
df = pd.read_sql(query, db)
df.head(3)

Error:

DatabaseError: Execution failed on SQL 'SELECT Machine,Epoch,Time,STATE FROM MSC where Epoch>=1623331800and Epoch<=1624195800;':

1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Epoch<=1624195800' at line 1

1623331800and. Notice anything?

juergen d
– juergen d

2021-07-27 05:08:15 +00:00
Commented Jul 27, 2021 at 5:08 — juergen d
– juergen d, Commented Jul 27, 2021 at 5:08
ops, my bad !!!

johnson
– johnson

2021-07-27 05:20:50 +00:00
Commented Jul 27, 2021 at 5:20 — johnson
– johnson, Commented Jul 27, 2021 at 5:20

hungnt03 · Accepted Answer · 2021-07-27 05:23:51Z

2

DatabaseError: Execution failed on SQL 'SELECT Machine,Epoch,Time,STATE FROM MSC where Epoch>=**1623331800and** Epoch<=1624195800;':

behind the condition of the epoch field, I think the error will resolve if you add 1 space before the "and" character.

answered Jul 27, 2021 at 5:23

hungnt03

615 bronze badges

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

Comments

DineshDB · Accepted Answer · 2021-07-27 05:11:28Z

1

The AND keyword concat with the value 1623331800and

Try the below:

startEpoch = 1623331800#july 10 7PM ePOCH
EndEpoch = 1624195800#july 20 7PM ePOCH

query = "SELECT `Machine`,`Epoch`,`Time`,`STATE` FROM MSC where `Epoch`>= " + str(startEpoch) + " and `Epoch`<= " + str(EndEpoch) + ";"
df = pd.read_sql(query, db)
df.head(3)

answered Jul 27, 2021 at 5:11

DineshDB

6,2238 gold badges38 silver badges54 bronze badges

Collectives™ on Stack Overflow

SQL syntax error when reading data from database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related