I didn’t read the code carefully, but the obvious problem is that there is no commit transcation after the insert statement’s executeinsert语句的execute之后没有commit transcation

解决方法：

在cur.execute('insert into ipList(ipList) values(%s)', ip_list[j])

Solution:

conn.commit()

If there is no exception, then it must be the InnoDB engine used for the database, right?
You have to commit the transaction. After executing all the statements, add conn.commit()Try

After inserting, you can use the command line to query or insert to see whether the database will be locked. . Just know if the matter is not over yet

Or turn on automatic submissionconn.autocommit(True)