On Thu, Dec 17, 2009 at 3:17 PM, <bangpypers-requ...@python.org> wrote:
> From: Santhosh Edukulla <santhosh.eduku...@gmail.com> > We are using MySQLdb module of python on FC11 box. We were able to > connect and execute a select statement on a remote mysql machine, but > the delete, insert and update operations are not working. > > This specific machine has the relevant permissions for > select,update,insert and delete operations on the mysql box. > > When the same code is run from a FC2 box, it is working fine.What > could be the issue here? > > Are you calling commit() after the update statements? The semantics of the db api - http://www.python.org/dev/peps/pep-0249/ - changed: " Note that closing a connection without committing the changes first will cause an implicit rollback " HTH, Vijay rollback to be performed. _______________________________________________ BangPypers mailing list BangPypers@python.org http://mail.python.org/mailman/listinfo/bangpypers
