Escape backslash in Python parameterized MySQL query

Question

I am working on excel files and database storaging, precisely I am storaging excel data to MySQL database. At some point I am executing this query:

query_for_id = ''' SELECT id FROM attivita WHERE attivita = '{0}' '''.format(attivita)

And when I print the query result I get this:

' SELECT id FROM attivita WHERE attivita = \\'Manutenzione\\' '

When it tries to match 'attivita' with the right value, taken from the excel, I got errors because of the '\\'.

I tried changing the triple quotes from " " " to ' ' ', as well as using connection.escape_string(), but I didn't solve the problem. Can anyone help me figuring out the problem? Thank you in advance.

Oleksandr Dashkov · Accepted Answer · 2016-10-11 10:29:29Z

1

I think that in your case better to use arguments to execute

query_for_id = ''' SELECT id FROM attivita WHERE attivita = %(attivita)s '''
cursor.execute(query_for_id, { 'attivita': attivita })

https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-execute.html

answered Oct 11, 2016 at 10:29

Oleksandr Dashkov

2,9781 gold badge20 silver badges31 bronze badges

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

Collectives™ on Stack Overflow

Escape backslash in Python parameterized MySQL query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related