simplified mysql transaction related methods