Process data and generate SQL insert statements in batches

Process data and generate sql insert statements in batches

I am currently working on a weather forecast module. First, I need to convert the client's public network IP to the city where it is located, and then convert the city name to the corresponding city. I found the city code on the Internet, but it needs to be processed. After looking at it, I found that there are more than 300 cities and corresponding city codes, and I want to save them in the database. I just want to make a tool that automatically generates SQL statements for data processing to improve efficiency.