How to resolve pymysql.err.ProgrammingError?

Question

Can't seem to figure out why I'm getting the error below for this python method in my script. I can't really post the full method here but it's erroring out at the return statement of the method which is:

return [{'parameters': [2022-02-21 00:00:00, 'US/Pacific', 2022-02-23 00:00:00, 'US/Pacific']}]

pymysql.err.ProgrammingError: (1064, '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 \'\'parameters\': "(\'2022-02-21 00:00:00\',\'US/Pacific\',\'2022-02-23 00:00:00\',\'US/Pacific\' at line 16')

Ricky Chau · Accepted Answer · 2022-02-24 14:46:14Z

1

That looks like a Python statement, is it possible you're confusing Python and SQL and trying to execute Python code as an SQL statement?

answered Feb 24, 2022 at 14:46

Ricky Chau

493 bronze badges

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

Collectives™ on Stack Overflow

How to resolve pymysql.err.ProgrammingError?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related