我正在尝试使用python的mysqldb模块创建一个包含2列的表，但出现错误，这里可能出什么问题了？
cur.execute("CREATE TABLE foreign_crew(id VARCHAR(45) PRIMARY_KEY, surname VARCHAR(45))")
Traceback (most recent call last):
File "<console>", line 1, in <module>
File "C:\Python27\lib\site-packages\MySQLdb\cursors.py", line 202, in execute
self.errorhandler(self, exc, value)
File "C:\Python27\lib\site-packages\MySQLdb\connections.py", line 36, in defaulterrorhandler
raise errorclass, errorvalue
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 ') PRIMARY_KEY, surname VARCHAR(45))' at line 1")
替换PRIMARY_KEY为PRIMARY KEY：
cur.execute("CREATE TABLE foreign_crew(id VARCHAR(45) PRIMARY KEY, surname VARCHAR(45))")
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句