mysql "rows affected"

[John Nagle]

Carl K wrote:
> using MySQLdb, I do cursor.execute("update...")
> 
> How can I tell how many rows were affected ?
> 
> Carl K

	cursor = db.cursor() # get cursor					
	cursor.execute(sqlstatement, argtuple) # do command
	rowsaffected = cursor.rowcount # get count of rows affected
	cursor.close() # close cursor
	db.commit() # commit transaction	

				John Nagle