Advertisement
Guest User

Untitled

a guest
Feb 23rd, 2019
168
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. #!/usr/bin/python3.6
  2. import sys, mysql.connector
  3.  
  4. db_host = "localhost"
  5. db_name = "database_name"
  6. db_user = "database_user"
  7. db_pass = "database_password"
  8.  
  9. con = mysql.connector.connect( host=db_host, database=db_name, user=db_user, password=db_pass )
  10. cur = con.cursor()
  11. query = "SELECT user_name, user_id FROM UserAccount"
  12. cur.execute(query)
  13. result = cur.fetchall()
  14. for (user_name, user_id) in result:
  15. print(user_name+" has the id "+str(user_id))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement