Predict the output of the following code:

Q. Predict the output of the following code:

import mysql.connector 
db = mysql.connector.connect(….) 
cursor db.cursor() 
sql1 = "update category set name = ‘%s’ WHERE ID = %s” % ('CSS',2)
cursor.execute(sql1) 
db.commit() 
print("Rows affected:", cursor.rowcount) 
db.close() 

Answer :-

>>> Rows affected : 1

Because ID is unique so, there will only one row with same data. so, Row affected by this code is only 1.