import MySQLdb db = MySQLdb.connect(host='localhost', port=3306, user='dave', passwd='evad', db='world') cur = db.cursor() print 'enter new name for Kabul:' newname = raw_input() query = "update City set Name='" + newname + "' where id=1" print query cur.execute(query) cur.close() db.close()