Python and SQLite: insert into table

by

there’s a better way 

# Larger example
rows = [('2006-03-28', 'BUY', 'IBM', 1000, 45.00),
        ('2006-04-05', 'BUY', 'MSOFT', 1000, 72.00),
        ('2006-04-06', 'SELL', 'IBM', 500, 53.00)]
c.executemany('insert into stocks values (?,?,?,?,?)', rows)
connection.commit()

More Related Contents:

  1. What is an efficient way of inserting thousands of records into an SQLite table using Django?
  2. Python pandas insert list into a cell
  3. Insert an element at a specific index in a list and return the updated list
  4. How can I get dict from sqlite query?
  5. Using a WHERE ___ IN ___ statement
  6. Insert element in Python list after every nth element
  7. How to add element in Python to the end of list using list.insert?
  8. TypeError: ‘float’ object is not subscriptable
  9. How to get a single result from a SQL query in python?
  10. Is this Python code vulnerable to SQL injection? (SQLite3)
  11. pysqlite: Placeholder substitution for column or table names?
  12. Python SQLite3 SQL Injection Vulnerable Code
  13. How to check the existence of a row in SQLite with Python?
  14. list extend() to index, inserting list elements not only to the end
  15. What does “list comprehension” and similar mean? How does it work and how can I use it?
  16. Iterate over all pairs of consecutive items in a list [duplicate]
  17. How Big can a Python List Get?
  18. Sum a list of numbers in Python
  19. Modify a list while iterating
  20. How do I create a list with numbers between two values?
  21. sqlalchemy: how to join several tables by one query?
  22. List assignment with [:]
  23. Identify if list has consecutive elements that are equal
  24. Python data structure sort list alphabetically
  25. What’s the difference between lists enclosed by square brackets and parentheses in Python?
  26. Difference between using [] and list() in Python
  27. SQLite Performance Benchmark — why is :memory: so slow…only 1.5X as fast as disk?
  28. Python: Elegant way to check if at least one regex in list matches a string
  29. How to delete a table in SQLAlchemy?
  30. How to extract all values from a dictionary in Python?

Leave a Comment