How to use python mysqldb to insert many rows at once

From MySQLdb User’s Guide:

c.executemany(
      """INSERT INTO breakfast (name, spam, eggs, sausage, price)
      VALUES (%s, %s, %s, %s, %s)""",
      [
      ("Spam and Sausage Lover's Plate", 5, 1, 8, 7.95 ),
      ("Not So Much Spam Plate", 3, 2, 0, 3.95 ),
      ("Don't Wany ANY SPAM! Plate", 0, 4, 3, 5.95 )
      ] )

so in your case:

c.executemany("insert into T (F1,F2) values (%s, %s)",
    [('a','b'),('c','d')])

Related Contents:

  1. Installing specific package version with pip
  2. Database does not update automatically with MySQL and Python
  3. mysql-python install error: Cannot open include file ‘config-win.h’
  4. How to insert pandas dataframe via mysqldb into database?
  5. Install mysql-python (Windows)
  6. When to close cursors using MySQLdb
  7. Python 3.4.0 with MySQL database
  8. Python MYSQL update statement
  9. How can I use executemany to insert into MySQL a list of dictionaries in Python
  10. ImportError: No module named MySQLdb
  11. Print the actual query MySQLdb runs?
  12. Can’t install mysql-python (newer versions) in Windows
  13. Dynamic SQL Queries with Python and mySQL
  14. What is PyMySQL and how does it differ from MySQLdb? Can it affect Django deployment?
  15. Visibility of global variables in imported modules
  16. Why do integers in database row tuple have an ‘L’ suffix?
  17. How to install Python MySQLdb module using pip?
  18. How can I connect to MySQL in Python 3 on Windows?
  19. “Cannot open include file: ‘config-win.h’: No such file or directory” while installing mysql-python
  20. How can I change the default Mysql connection timeout when connecting through python?
  21. How to install MySQLdb (Python data access library to MySQL) on Mac OS X?
  22. Integrating MySQL with Python in Windows
  23. Enable Python to Connect to MySQL via SSH Tunnelling
  24. Inserting a Python datetime.datetime object into MySQL
  25. How to replace Django’s primary key with a different integer that is unique for that table
  26. Using Django database layer outside of Django?
  27. Python: use mysqldb to import a MySQL table as a dictionary?
  28. Cannot return results from stored procedure using Python cursor
  29. MySQL — Joins Between Databases On Different Servers Using Python?
  30. How to enable MySQL client auto re-connect with MySQLdb?
  31. SQLAlchemy ON DUPLICATE KEY UPDATE
  32. Python Mysql, “commands out of sync; you can’t run this command now”
  33. How to build a flask application around an already existing database?
  34. Python MySQLdb execute table variable [duplicate]
  35. Python and MySQLdb: substitution of table resulting in syntax error
  36. ImportError: No module named ‘MySQL’
  37. Python mySQL Update, Working but not updating table
  38. Python import MySQLdb error – Mac 10.6
  39. Python Pandas to_sql, how to create a table with a primary key?
  40. Speeding (Bulk) Insert into MySQL with Python
  41. How to run Django’s test database only in memory?
  42. Python MySQLdb: connection.close() VS. cursor.close()
  43. Python: MySQLdb and “Library not loaded: libmysqlclient.16.dylib”
  44. cursor.fetchall() vs list(cursor) in Python
  45. How to filter (or replace) unicode characters that would take more than 3 bytes in UTF-8?
  46. Using MySQL in Flask
  47. How to make an Inner Join in django?
  48. Single Django model, multiple tables?
  49. MySQL Improperly Configured Reason: unsafe use of relative path
  50. How can I insert NULL data into MySQL database with Python?

Leave a Comment