import MySQLdb

db = MySQLdb.connect(host='localhost', port=3306, user='dave', passwd='evad', 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()

query = "insert into City (Name, CountryCode, Population) values (%s,%s,%s)"

cur.execute(query, (name,code,population))

cur.close()
db.close()