MariaDB query from python code

Question

I'm writing a python script that connects to a MariaDB server (V 10.1.12) and saves to file the results of some queries. However, when sending the following query:

sql =   'SELECT * FROM Monitor_Run_Tracking WHERE Entry IN (SELECT MAX(Entry) ' \
        'FROM Monitor_Run_Tracking WHERE Run in ({0}) ' \
        "AND WhenEntered<'{1}' GROUP BY Run)".format( runstr, quality_date )

followed by cursor.execute( sql ), I get the following error:

File "build/bdist.linux-x86_64/egg/MySQLdb/cursors.py", line 174, in execute
File "build/bdist.linux-x86_64/egg/MySQLdb/connections.py", line 36, in defaulterrorhandler _mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND WhenEntered<'2020-01-01' GROUP BY Run)' at line 1")

Could someone explain to me what the mistake is?

Thanks!

runstr is a string of numbers separated by comma: 'runstr = 60092,60093,60094' — id5h
– id5h, Commented Jul 12, 2016 at 14:00

Community · Accepted Answer · 2017-05-23 12:32:40Z

1

You didn't close the parenthesis around the nested select. It should be

SELECT * FROM Monitor_Run_Tracking WHERE Entry IN (
        SELECT MAX(Entry)
        FROM Monitor_Run_Tracking WHERE Run in ({0})
        AND WhenEntered<'{1}')
GROUP BY Run

or

SELECT * FROM Monitor_Run_Tracking WHERE Entry IN (
        SELECT MAX(Entry)
        FROM Monitor_Run_Tracking WHERE Run in ({0})
        AND WhenEntered<'{1}'
        GROUP BY Run)

EDIT: For the other problem, you're grouping by a field that you're not selecting. Check out this question for help.

edited May 23, 2017 at 12:32

CommunityBot

11 silver badge

answered Jul 12, 2016 at 14:06

Nee

5862 silver badges17 bronze badges

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

2 Comments

id5h Over a year ago

Sorry, that mistake was a copy and paste from a one of my debugging iterations. It was originally closed properly. I edited the question appropriately now. Thanks

Nee Over a year ago

Edited my answer with a link that should resolve your problem.

Collectives™ on Stack Overflow

MariaDB query from python code

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related