What if pymysql splices multiple sql statements and reports an error?

sql statements are
all INSERT statements saved in the sql.sql file, not omitted ";"

* *

< H2 > the following code can be executed < / H2 >

* *

with open("sql/sql.sql", "r", encoding="utf-8") as f:
    for each_line in f.readlines():
        if not each_line or each_line == "\n":
            continue
        cur.execute(each_line.strip())
        conn.commit()

but an error will be reported after splicing sql

with open("sql/sql.sql", "r", encoding="utf-8") as f:
    for each_line in f.readlines():
        if not each_line or each_line == "\n":
            continue
        elif count < 50:
            sql += each_line.strip()
            count += 1
        else:
            cur.execute(sql)
            conn.commit()
            sql = each_line
            count = 1
    if sql:
        cur.execute(sql)
        conn.commit()

error message

Traceback (most recent call last):
  File "main.py", line 135, in <module>
    db.readSQL()
  File "db.py", line 118, in readSQL
    cur.execute(sql)
  File "d:\Anaconda3\App\lib\site-packages\pymysql\cursors.py", line 165, in execute
    result = self._query(query)
  File "d:\Anaconda3\App\lib\site-packages\pymysql\cursors.py", line 321, in _query
    conn.query(q)
  File "d:\Anaconda3\App\lib\site-packages\pymysql\connections.py", line 860, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  File "d:\Anaconda3\App\lib\site-packages\pymysql\connections.py", line 1061, in _read_query_result
    result.read()
  File "d:\Anaconda3\App\lib\site-packages\pymysql\connections.py", line 1349, in read
    first_packet = self.connection._read_packet()
  File "d:\Anaconda3\App\lib\site-packages\pymysql\connections.py", line 1018, in _read_packet
    packet.check_error()
  File "d:\Anaconda3\App\lib\site-packages\pymysql\connections.py", line 384, in check_error
    err.raise_mysql_exception(self._data)
  File "d:\Anaconda3\App\lib\site-packages\pymysql\err.py", line 107, in raise_mysql_exception
    raise errorclass(errno, errval)
pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near "INSERT INTO abc (()," at line 1")

what should I do about this?

also, the database reports an error

Got a packet bigger than "max_allowed_packet" bytes

max_allowed_packet=500M

my.ini

just restart the database.

Python

Mar.11,2021