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

This article is to share with you about how to use Update to modify data in MySQL. The editor thinks it is very practical, so I share it with you. I hope you can get something after reading this article.

1. Parameters

2. Test steps

Session1

Session2

Session1

3. Summary

In binlog_format=row

And binlog_row_image=FULL

Because the MySQL needs to record all the fields in the binlog, all the data will be read out when the data is read, and the update of the duplicate data will not be executed. That is, MySQL invokes the interface "modified to (1cm55)" provided by the InnoDB engine, but the engine finds that the value is the same as the original, does not update, and returns directly.

4. Binlog_format is STATEMENT

1. Parameters

2. Test steps

Session1

Session2

Session1

3. Summary

In binlog_format=statement

And binlog_row_image=FULL

The update statement is carefully executed within InnoDB, that is, the operation of "change this value to (1999)", the lock that should be locked, the update that should be updated.

The above is how to use Update to modify data in MySQL. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

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.