Re: db.commit() to take effect

John Machin wrote: > progman wrote: > >>I was testing the python+mysql >> >>here are my sample codes: >> >>import MySQLdb >>from pprint import pprint >>db = MySQLdb.connect(host="localhost", user="root", passwd="password", >>db="database") >>cursor = db.cursor() >>cursor.ex

Re: db.commit() to take effect

progman wrote: > I was testing the python+mysql > > here are my sample codes: > > import MySQLdb > from pprint import pprint > db = MySQLdb.connect(host="localhost", user="root", passwd="password", > db="database") > cursor = db.cursor() > cursor.execute('update promo set

db.commit() to take effect

I was testing the python+mysql here are my sample codes: import MySQLdb from pprint import pprint db = MySQLdb.connect(host="localhost", user="root", passwd="password", db="database") cursor = db.cursor() cursor.execute('update promo set date=100") --