In MySQLdb you do something similar to
Records = [ (1,2,3), (4,5,6), (7,8,9) , (11,22,33) ]
cursor.execute('insert to mytable (a,b,c) VALUES (%s, %s, %s)', Records)
#untested.
This would insrt 4 rows
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Kenneth Gonsalves
Sent: Thursday, July 08, 2010 8:46 PM
To: [email protected]
Subject: Re: How can I Insert multiple records in one statement
On Friday 09 July 2010 06:03:09 Sells, Fred wrote:
> I know how to do this in raw MySQLdb and have been trying to find a
way
> to do it with the Django models but with no success.
>
how do you do it in MySQLdb? What exactly do you mean by 'insert
multiple
records in one statement'?
--
Regards
Kenneth Gonsalves
Senior Associate
NRC-FOSS at AU-KBC
--
You received this message because you are subscribed to the Google
Groups "Django users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
