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: django-users@googlegroups.com [mailto:django-us...@googlegroups.com] On Behalf Of Kenneth Gonsalves Sent: Thursday, July 08, 2010 8:46 PM To: django-users@googlegroups.com 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 django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. 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 django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.