import MySQLdb

db = MySQLdb.connect("localhost","testuser","test123","TESTDB" )
cursor = db.cursor()

sql = 'UPDATE student SET age = age + 1 WHERE sex="man"'
cursor.execute(sql)
print(cursor.rowcount)
# 20

db.close()