Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import mysql.connector
- cnx = mysql.connector.connect(
- user='marcbot2',
- password='marcbot2',
- host='107.180.50.243',
- database='KLYS2')
- cursor = cnx.cursor()
- query = ("SELECT city FROM Realestate")
- cursor.execute(query)
- data = cursor.fetchall()
- print(data[0],data[1])
- cnx.commit()
- cnx.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement