How to use python mysqldb to insert many rows at once

by

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')])

More 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 MYSQL update statement
  8. Python 3.4.0 with MySQL database
  9. How can I use executemany to insert into MySQL a list of dictionaries in Python
  10. MySQL: Get column name or alias from query
  11. ImportError: No module named MySQLdb
  12. Print the actual query MySQLdb runs?
  13. Can’t install mysql-python (newer versions) in Windows
  14. Dynamic SQL Queries with Python and mySQL
  15. What’s the difference between MySQLdb, mysqlclient and MySQL connector/Python?
  16. ‘pip install MySQL-python’ fails with ‘IndexError’
  17. What is PyMySQL and how does it differ from MySQLdb? Can it affect Django deployment?
  18. How to disable query cache with mysql.connector
  19. How do I connect to a MySQL Database in Python?
  20. Why do integers in database row tuple have an ‘L’ suffix?
  21. “Cannot open include file: ‘config-win.h’: No such file or directory” while installing mysql-python
  22. Python mysqldb: Library not loaded: libmysqlclient.18.dylib
  23. Not all parameters were used in the SQL statement (Python, MySQL)
  24. Installing MySQL Python on Mac OS X
  25. How to efficiently use MySQLDB SScursor?
  26. How to run Django’s test database only in memory?
  27. Using MySQL in Flask
  28. Can one use the Django database layer outside of Django?
  29. How to make an Inner Join in django?
  30. flask-login: can’t understand how it works

Leave a Comment