Python read from txt and save into mysql

by

Next step is simple:

from contextlib import closing

with closing(self.db.cursor()) as cur:
    cur.execute("INSERT INTO table1(`measured_at`,`temp`) VALUES(%s, %s)", (measured_at,  temp))
    self.db.commit()

P.S. It looks like you ask this question because you didn’t make your homework and didn’t read via ANY python tutorial how to work with MySQL.

More Related Contents:

  1. MySQL parameterized queries
  2. PyInstaller, spec file, ImportError: No module named ‘blah’
  3. How to install Python MySQLdb module using pip?
  4. How to convert SQL Query result to PANDAS Data Structure?
  5. Escape string Python for MySQL
  6. pip install mysqlclient returns “fatal error C1083: Cannot open file: ‘mysql.h’: No such file or directory
  7. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  8. Load CSV data into MySQL in Python
  9. Enable Python to Connect to MySQL via SSH Tunnelling
  10. Inserting a Python datetime.datetime object into MySQL
  11. How to replace Django’s primary key with a different integer that is unique for that table
  12. MySQL — Joins Between Databases On Different Servers Using Python?
  13. Error loading MySQLdb Module ‘Did you install mysqlclient or MySQL-python?’
  14. Using a Python dict for a SQL INSERT statement
  15. Python Mysql, “commands out of sync; you can’t run this command now”
  16. How do I escape % from python mysql query
  17. Bulk insert with SQLAlchemy ORM
  18. RuntimeError: working outside of application context
  19. Why are some mysql connections selecting old data the mysql database after a delete + insert?
  20. ImportError: No module named MySQLdb
  21. Can’t install mysql-python (newer versions) in Windows
  22. Using Django database layer outside of Django?
  23. How to move a model between two Django apps (Django 1.7)
  24. How do i cast char to integer while querying in django ORM?
  25. flake8 complains on boolean comparison “==” in filter clause
  26. How do I get time from a datetime.timedelta object?
  27. Python issue:Unable to find vcvarsall.bat [duplicate]
  28. Context manager for Python’s MySQLdb
  29. Retrieve query results as dict in SQLAlchemy
  30. What is PyMySQL and how does it differ from MySQLdb? Can it affect Django deployment?

Leave a Comment