Python Database Where Clause

We can restrict the result produced by the select statement by using the where clause. This will extract only those columns which satisfy the where condition.

Python Database Where Clause Example

import mysql.connector  
myconn = mysql.connector.connect(host = "localhost", user = "root",password = "gkindex",database = "PythonDB")  
cur = myconn.cursor()    
try:  
    cur.execute("select name, id, salary from Employee where name like 'J%'")  
    result = cur.fetchall()    
    print("Name    id    Salary");   
    for row in result:  
        print("%s    %d    %d"%(row[0],row[1],row[2]))  
except:  
    myconn.rollback()    
myconn.close()

import mysql.connector  
myconn = mysql.connector.connect(host = "localhost", user = "root",password = "gkindex",database = "PythonDB")  
cur = myconn.cursor()    
try:  
    cur.execute("select name, id, salary from Employee where id in (101,102,103)")  
    result = cur.fetchall()    
    print("Name    id    Salary");    
    for row in result:  
        print("%s\t%d\t%d"%(row[0],row[1],row[2]))  
except:  
    myconn.rollback()  
myconn.close()