Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/usr/bin/python3.6
- import sys, mysql.connector
- db_host = "localhost"
- db_name = "database_name"
- db_user = "database_user"
- db_pass = "database_password"
- con = mysql.connector.connect( host=db_host, database=db_name, user=db_user, password=db_pass )
- cur = con.cursor()
- query = "SELECT user_name, user_id FROM UserAccount"
- cur.execute(query)
- result = cur.fetchall()
- for (user_name, user_id) in result:
- print(user_name+" has the id "+str(user_id))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement