executing django query in same statement

Question

This might be a silly question. Is there a way to execute multiple queries in one execute statement?

cursor = conn.cursor()
cursor.execute("Select * from my_tables; show tables;")
result = cursor.fetchall()

No you can't do that, cursor.execute(sql, [params]) It takes one sql statement and params list (optional). Maybe you are looking for subqueries (MySQL Subqueries)? — Aamir Rind
– Aamir Rind, Commented Jun 17, 2013 at 13:38
you can always execute raw SQL statements like this: docs.djangoproject.com/en/dev/topics/db/sql — karthikr
– karthikr, Commented Jun 17, 2013 at 13:39
Thanks for the fast replies. The reason that i want to do this is because i am creating a sql injectable platform for class room purposes. So wiht cursore.execute(sql, [params]) will not work in that aspect. Do you know of any way that i can perform sql inject queries in python? — user1817081
– user1817081, Commented Jun 17, 2013 at 13:41

Aya · Accepted Answer · 2013-06-17 14:39:43Z

1

Looks like the CLIENT_MULTI_STATEMENTS and CLIENT_MULTI_RESULTS options are enabled by default in MySQLdb (which is quite disturbing), so you can do something like this...

>>> import MySQLdb
>>> conn = MySQLdb.connect(db='test')
>>> cur = conn.cursor()
>>> cur.execute('select * from foo; show tables;')
2L
>>> cur.fetchall()
((1L,), (1L,))
>>> cur.nextset()
1
>>> cur.fetchall()
(('foo',),)

If you want to demonstrate an example which makes changes to an InnoDB table, you'll have to commit the transaction with something like...

>>> cur.execute('select * from foo; insert into foo values (123);')
2L
>>> cur.nextset()
1
>>> conn.commit()
>>> cur.execute('select * from foo')
3L
>>> cur.fetchall()
((1L,), (1L,), (123L,))

Check out PEP249 for the meaning of all the return values.

edited Jun 17, 2013 at 14:39

answered Jun 17, 2013 at 14:27

Aya

42.5k6 gold badges60 silver badges56 bronze badges

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

Collectives™ on Stack Overflow

executing django query in same statement

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