执行mysql update 语句设置navicat不自动提交

set autocommit = 0;  //1是自动提交
update innodb_lock set b = '1234' where a > 1 and a < 6; //这里写update更新语句
commit; //或者rollback;