PROGRAMMING EXAMPLES

M YSQL WHERE Select With a Filter When selecting records from a table, you can filter the selection by using the "WHERE" statement: import mysql.connector mydb = mysql.connector.connect(   host="localhost",   user="myusername",   password="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) sql = "SELECT * FROM customers WHERE address Like '%way%'" mycursor.execute(sql) myresult = mycursor.fetchall() for x in myresult: print(x) mycursor.close() mydb.close() (11, 'Ben', 'Park Lane 38') (1, 'John', 'Highway 21') (9, 'Susan', 'One way 98') (14, 'Viola', 'Sideway 1633') Prevent SQL Injection W hen query values are provided by t

M YSQL SELECT Select From a Table To select from a table in MySQL, use the "SELECT" statement: import mysql.connector mydb = mysql.connector.connect(   host="localhost",   user="myusername",   password="mypassword",   database="mydatabase" ) mycursor = mydb.cursor() mycursor.execute("SELECT * FROM customers") myresult = mycursor.fetchall() for x in myresult:   print(x) mycursor.execute("SELECT name, address FROM customers") myresult = mycursor.fetchall() for x in myresult:    print(x) mycursor.execute("SELECT * FROM customers") myresult = mycursor.fetchone() print(myresult) mycursor.close() mydb.close() (1, 'John', 'Highway 21') (2, 'Peter', 'Lowstreet 27') (3, 'Amy', 'Apple st 652') (4, 'Hannah', 'Mountain 21') (5, 'Michael', 'Valley 345') (6, 'Sandy', 'Ocea