我正在尝试用python和mysql开发一个考勤记录系统。我有一个列表,其中填充了'a'和'p'值。此列表等于当前的卷数。现在,每当我运行python代码时,应该将这个列表添加到以datestamp为列的表中。在
错误就是每次代码出错:
完成列表:-在['P', 'P', 'P', 'A', 'P', 'P', 'P', 'P', 'A', 'P', 'P', 'P', 'P', 'P', 'P', 'P', 'P', 'P', 'P', 'P']
缺席卷数:
^{pr2}$
当前卷数:[1, 2, 3, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20]
写入数据库:Traceback (most recent call last):
File "take.py", line 47, in
cursor.execute("ALTER TABLE student ADD column datestamp Date;")`enter code here`
File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
self.errorhandler(self, exc, value)
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1060, "Duplicate column name 'datestamp'")