How to modify data in batch by Mysql

This article mainly explains "how to modify data in batch by Mysql". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "how to modify data in batches by Mysql".

In Mysql

We often use update to modify an object.

If the content of a filed is 123xyz890, the object will be changed to 123abc890 by the following modification.

Update `table_ name` set `filed_name = 123abc890 where.

If we want to change the xyz in all objects that contain xyz into abc, we can do it through replace with update. As follows:

Update `table_ name` set filed_name = REPLACE (filed_name, "xyz", "abc")

If you want to further constrain the modified object group, you can also add where after it.

Update `table_ name` set filed_name = REPLACE (filed_name, "xyz", "abc") where. At this point, I believe you have a better understanding of "how to modify data in batches by Mysql". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!