使用python在数据库中创建啊表出现了错误,请大神帮忙解答一下
import pymysql# 连接数据库 并添加cursor游标conn = pymysql.connect('localhost','root','password','politicspeech')
cur = conn.cursor()
sql = """CREATE TABLE SPEECH_DATA (INDEX INT,
TITLE VARCHAR(100) NOT NULL,
CONTENT TEXT,
TIME VARCHAR(100),
EDITOR VARCHAR(100),
primary key(TITLE))"""
cur.execute(sql)
conn.commit()
conn.close()
cur.close()
显示报错为:Traceback (most recent call last): File "E:/PythonProject/网络爬虫/网络爬虫-MySql.py", line 11, in <module> cur.execute(sql) File "C:UsersinitialAnaconda3libsite-packagespymysqlcursors.py", line 170, in execute result = self._query(query) File "C:UsersinitialAnaconda3libsite-packagespymysqlcursors.py", line 328, in _query conn.query(q) File "C:UsersinitialAnaconda3libsite-packagespymysqlconnections.py", line 517, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "C:UsersinitialAnaconda3libsite-packagespymysqlconnections.py", line 732, in _read_query_result result.read() File "C:UsersinitialAnaconda3libsite-packagespymysqlconnections.py", line 1075, in read first_packet = self.connection._read_packet() File "C:UsersinitialAnaconda3libsite-packagespymysqlconnections.py", line 684, in _read_packet packet.check_error() File "C:UsersinitialAnaconda3libsite-packagespymysqlprotocol.py", line 220, in check_error err.raise_mysql_exception(self._data) File "C:UsersinitialAnaconda3libsite-packagespymysqlerr.py", line 109, 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 'INT, TITLE VARCHAR(100) NOT NULL, CONTENT TEXT, ' at line 1")
你的SQL有错,你把系统关键字INDEX作为字段名了
将它改成其它名字,如mINDEX就可以了
上一篇:纯新手小白c语言问题