mysql3.py

# Script to insert a new city into the example 'world' database

import MySQLdb

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

print "enter new city's name:"
name = raw_input()
print "enter new city's country code:"
code = raw_input()
print "enter new city's population:"
population = raw_input()

# Note: this uses a parameterized query in order to make sure the data is safe

query = "insert into City (Name, CountryCode, Population) values (%s,%s,%s)"
cur.execute(query, (name,code,population))

cur.close()
db.close()