实际使用sqlite3数据库发现,用alter往表格里添加column,每次跑到2000左右总会出错,
写了个脚本测试发现确实如此:
Traceback (most recent call last):
File ".\sqlite_col_test.py", line 91, in <module>
conn.execute(sql)
sqlite3.OperationalError: too many columns on sqlite_altertab_my_table
写了个脚本测试发现确实如此:
Traceback (most recent call last):
File ".\sqlite_col_test.py", line 91, in <module>
conn.execute(sql)
sqlite3.OperationalError: too many columns on sqlite_altertab_my_table