Advertisement
Guest User

Untitled

a guest
Jun 10th, 2016
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. import mysql.connector
  2. import numpy as np
  3.  
  4. cnx = mysql.connector.connect(user='user', password='pw, host='ip_here')
  5. for i,j in enumerate(columnList):
  6. cursor.execute('SELECT `' + j + '` FROM `table_name`
  7. iValues = cursor.fetchall()
  8. cursor.close
  9. if i == 0:
  10. extractedValues = iValues
  11. else:
  12. extractedValues = np.hstack((extractedValues, iValues))
  13.  
  14. cnx.close
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement