Thursday, November 30, 2023

Python to Mysql Connectivity

 import mysql.connector

connection = mysql.connector.connect( host="localhost", user="yourusername", password="yourpassword", database="mydatabase" ) mycursor = connection.cursor() mycursor.execute("SELECT name, address FROM customers") myresult = mycursor.fetchall() for x in myresult: print(x)

No comments:

Post a Comment