MySQL Connector/Python

Inserting multiple rows

Asked by armakuni

When inserting data it's possible to insert multiple rows with executemany(). I'm not sure does this create many queries or does it insert multiple rows at same time? If not, could it also support inserting multiple rows at the same time?

Example:
http://dev.mysql.com/doc/refman/5.1/en/insert.html
INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);

Question information

Language:
English Edit question
Status:
Answered
For:
MySQL Connector/Python Edit question
Assignee:
Geert JM Vanderkelen Edit question
Last query:
Last reply:
Revision history for this message
Geert JM Vanderkelen (geertjmvdk) said : 		#1

MySQL Connector/Python v0.1 doesn't do this no, but it will eventually get into future version to optimize INSERT statements.

Can you help with this problem?

Provide an answer of your own, or ask armakuni for more information if necessary.

To post a message you must log in.