Re: Insert Multiple Records Using One Insert Statemen with MySQLdb module

2008-12-06 Thread Albert Hopkins
On Sat, 2008-12-06 at 04:03 -0800, [EMAIL PROTECTED] wrote: > Hi, > > I'd like to insert Multiple Records Using One Insert Statement > > inserting one record using one insert statement works > this is the example: > > import MySQLdb > conn = MySQLdb.connect(host="localhost",.) > cursore = co

Insert Multiple Records Using One Insert Statemen with MySQLdb module

2008-12-06 Thread anton . ranieri . it
Hi, I'd like to insert Multiple Records Using One Insert Statement inserting one record using one insert statement works this is the example: import MySQLdb conn = MySQLdb.connect(host="localhost",.) cursore = conn.cursor() cursore.execute('INSERT INTO frutta (nome, quantita) VALUES(%s, %s)'