Advertisement
Guest User

Untitled

a guest
Mar 1st, 2017
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. ```shell
  2. sudo easy_install pip
  3. sudo pip install mysql-connector
  4. python
  5.  
  6. >>> import mysql.connector
  7. >>> conn = mysql.connector.connect(user='root', password='pwd', host='192.168.241.129', database='test')
  8. >>> cur = conn.cursor()
  9. >>> cur.execute('select * from foo')
  10. >>> result = cur.fetchall()
  11. >>> print result
  12. [(u'Bing Zhang', 33), (u'Bndy', 23)]
  13. >>> conn.close()
  14. ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement