Advertisement
Guest User

Untitled

a guest
Aug 4th, 2019
372
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. import MySQLdb
  2. import MySQLdb.cursors
  3. import mysql.connector
  4.  
  5. db = MySQLdb.connect(user="ReportReader", password="MyPassword, host="10.1.10.95, database="database")
  6. cursor = db.cursor()
  7. cursor.execute("SELECT TimeStr, Value FROM batch_device1")
  8.  
  9. data = cursor.fetchall()
  10. for row in data:
  11. print(row[0], row[1])
  12.  
  13. db.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement