Shulou(Shulou.com)06/02 Report--

This article is about how sublime uses regulars to modify data in batches. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

The requirements are as follows:

Remove the letters and numbers in front of these knowledge points

If you use php scripts to change one by one, because the amount of data is too large, it may cause data congestion, or the server crashes.

Here, use the sublime editor to open the sql file for the table, regularly query these prefixes, batch replace them with empty, and then rerun sql to generate the data table.

The regular statement is as follows:

In this way, the seemingly complicated problem has been solved.

Thank you for reading! About sublime using regular batch modification of data to share here, I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

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.