Load CSV data into MySQL in Python

by

I think you have to do mydb.commit() all the insert into.

Something like this

import csv
import MySQLdb

mydb = MySQLdb.connect(host="localhost",
    user="root",
    passwd='',
    db='mydb')
cursor = mydb.cursor()

csv_data = csv.reader(file('students.csv'))
for row in csv_data:

    cursor.execute('INSERT INTO testcsv(names, \
          classes, mark )' \
          'VALUES("%s", "%s", "%s")', 
          row)
#close the connection to the database.
mydb.commit()
cursor.close()
print "Done"

More Related Contents:

  1. mysql to pdf – python or ruby [closed]
  2. Installing specific package version with pip
  3. How can I connect to MySQL in Python 3 on Windows?
  4. Python & MySql: Unicode and Encoding
  5. Authentication plugin ‘caching_sha2_password’ is not supported
  6. memory-efficient built-in SqlAlchemy iterator/generator?
  7. Install mysql-python (Windows)
  8. When to close cursors using MySQLdb
  9. Installing MySQL Python on Mac OS X
  10. How to build a flask application around an already existing database?
  11. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
  12. SQLAlchemy ON DUPLICATE KEY UPDATE
  13. Python 3.4.0 with MySQL database
  14. How to efficiently use MySQLDB SScursor?
  15. Python MySql Insert not working
  16. What is the best solution for database connection pooling in python?
  17. How to run Django’s test database only in memory?
  18. Using MySQL in Flask
  19. trapping a MySql warning
  20. Repeated MySQL queries from Python return the same data [duplicate]
  21. Can one use the Django database layer outside of Django?
  22. Python mySQL Update, Working but not updating table
  23. ImportError: No module named ‘MySQL’
  24. Python import MySQLdb error – Mac 10.6
  25. mysql-python installation problems (on mac os x lion)
  26. How to make an Inner Join in django?
  27. Dynamic SQL Queries with Python and mySQL
  28. Simple Subquery with OuterRef
  29. pip install mysqlclient : Microsoft Visual C++ 14.0 is required
  30. Installing mysql-python on Centos

Leave a Comment