Home > Article > Backend Development > Change the Chinese name of the region in the region table in the database
I currently have more than 3,000 pieces of data in the database region table. My current need is to convert the region name in each row of records into English (that is, Chinese Pinyin) and save it at the same time. The attached picture is more intuitive
I would like to ask if there is a Chinese language library. I write a PHP program myself to convert Chinese into Pinyin, and then insert it in batches through SQL statements. I can't change it line by line.
What can you do? ? Please answer