Django: MySQL syntax error when passing parameters to raw SQL query

Question

I'm trying to perform a raw SQL query, like so

test = Poll.objects.raw('SELECT * FROM %s', ['polls_poll'])

and it results in an error:

ProgrammingError at ...

(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax...

Debug Toolbar shows that Django performs the following SQL query:

SELECT * FROM 'polls_poll'

If I execute this query directly in the MySQL shell, it won't work either, unless I replace single quotes (') with backticks (`).

How do I make Django use backticks? Or what am I doing wrong?

Environment: Django 1.6, MySQL 5.6.14, OS X 10.9.

richardson · Accepted Answer · 2013-12-02 11:49:03Z

4

I think you can only pass query parameters, not field names, so it will not work for table names.

Alternatively, you can try simple string building for your query:

test_query = 'SELECT * FROM %s' % 'polls_poll'
test = Poll.objects.raw(test_query)

Although, string formatting for raw queries is not recommended.

More information: https://docs.djangoproject.com/en/dev/topics/db/sql/#passing-parameters-into-raw

edited Dec 2, 2013 at 11:49

answered Dec 2, 2013 at 0:40

richardson

4563 silver badges4 bronze badges

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

2 Comments

Dae Over a year ago

Thanks, but it does not work. global name 'polls_poll' is not defined

richardson Over a year ago

Thanks, I have improved my answer!

Collectives™ on Stack Overflow

Django: MySQL syntax error when passing parameters to raw SQL query

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related