Home  >  Article  >  Backend Development  >  Change the Chinese name of the region in the region table in the database

Change the Chinese name of the region in the region table in the database

WBOY
WBOYOriginal
2016-09-05 08:44:43929browse

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

Change the Chinese name of the region in the region table in the database

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

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn