Where_query.py

#Select with a filter 

import mysql.connector 

mydb = mysql.connector.connect(
    host = "localhost",
    user = "root", 
    password = "",
    database = "my_database"
)
mycursor = mydb.cursor()
sql = "SELECT * FROM customers WHERE address ='Park Lane 38'"
mycursor.execute(sql)
myresult = mycursor.fetchall()
for x in myresult:
  print(x)



#Prevent SQL Injection
import mysql.connector 

mydb = mysql.connector.connect(
    host = "localhost",
    user = "root", 
    password = "",
    database = "my_database"
)
mycursor = mydb.cursor()
sql = "SELECT * FROM customers WHERE address = %s"
adr = ("Yellow Garden 2", )
mycursor.execute(sql, adr)
myresult = mycursor.fetchall()
for x in myresult:
  print(x)