Shulou(Shulou.com)05/31 Report--

This article mainly explains "what is the relationship between autocommit and sql rollback in mysql". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "what is the relationship between autocommit and sql rollback in mysql"!

The relationship between autocommit and sql rollback in mysql

Today, someone in the group asked whether an error in sql execution in mysql would be rolled back. The first feeling is that the answer should have something to do with autocommit.

First of all, explain the background and repeat the question:

Perform sql:

Www.2cto.com

one

Root@wlb 12:48:30 > update wlb_schedule_02 set status=status*10 where gmt_create

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.