Result Size: 625 x 571
demo_mysql_where.py:
x
 
import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="myusername",
  passwd="mypassword",
  database="mydatabase"
)
mycursor = mydb.cursor()
sql = "SELECT * FROM customers WHERE address = 'Park Lane 38'"
mycursor.execute(sql)
myresult = mycursor.fetchall()
for x in myresult:
  print(x)
C:\Users\My Name>python demo_mysql_where.py
(11, 'Ben', 'Park Lane 38')