Question 3 - Past Year - 2 Mark Questions - Chapter 15 - Interface of Python with SQL Database

Fetchone( )

Fetches one row from the resultset. It will return None if there are no more rows in the resultset.

Example:

import mysql.connector 

mydb=mysql.connector.connect("localhost","root","root","ABC") cursor=mydb.cursor()

sql="select * from employee"

cursor.execute(sql)

result=cursor.fetchone()

print(result)

cursor.close()

mydb.close()

import mysql.connector 

mydb=mysql.connector.connect("localhost","root","root","ABC")

cursor=mydb.cursor()

sql="select * from employee"

cursor.execute(sql)

result=cursor.fetchall()

for row in result:

    print(row)

cursor.close()

mydb.close()