mysql2.py

# Perform an 'update' query on the sample database, with data input by the user

import MySQLdb

db = MySQLdb.connect(host='localhost', port=3306, user='myusername', passwd='mypassword', db='world')
cur = db.cursor()

print 'enter new name for City 1:'
newname = raw_input()

# Include the data in the query; *NOTE* that this does not do any safety checks / escaping of the data - it's an easy target for an SQL injection attack
query = "update City set Name='" + newname + "' where id=1"

print query
cur.execute(query)


cur.close()
db.close()