python中文列名报错__mssql.MSSQLDatabaseException：（207，b“无效列名'Hello'。DBLib错误消息20018...

我想把记事本的数据插入数据库，但是有一个错误：Traceback (most recent call last): File "src\pymssql.pyx", line 448,

in pymssql.Cursor.execute File "src_mssql.pyx", line 1061, in

_mssql.MSSQLConnection.execute_query File "src_mssql.pyx", line 1092, in _mssql.MSSQLConnection.execute_query File "src_mssql.pyx",

line 1225, in _mssql.MSSQLConnection.format_and_run_query File

"src_mssql.pyx", line 1636, in _mssql.check_cancel_and_raise File

"src_mssql.pyx", line 1680, in

_mssql.maybe_raise_MSSQLDatabaseException

_mssql.MSSQLDatabaseException: (207, b"Invalid column name 'Hello'.DB-Lib error message 20018, severity 16:\nGeneral SQL Server

error: Check messages from the SQL Server\n"

我的python代码：# -*- coding: UTF-8 -*-

import pandas as pd

import pymssql

def insert_report_pn_dictionary(server, user, password, database):

pn_df = pd.read_csv(r'D:/20180605_dict.txt', \

sep=':',

encoding='utf-8',

names=('Word', 'Reading', 'POS', 'PN')

)

word_list = list(pn_df['Word'])

pn_list = list(pn_df['PN'])

pn_dict = dict(zip(word_list, pn_list))

dict_list = []

for key,value in pn_dict.items():

dict_list.append([key,value])

try:

conn = pymssql.connect(server, user, password, database)

cur = conn.cursor()

for item in dict_list:

sql = ' insert into report_pn_dictionary (dict_keyword, dict_pn) ' \

' values(%s, %s) ' % (item[0], item[1])

cur.execute(sql)

conn.commit()

except pymssql.Error as ex:

raise ex

except Exception as ex:

raise ex

finally:

conn.close()

if __name__=="__main__":

server = '10.10.2.20'

user = 'test'

password = 'test'

database = 'DBAL'

insert_report_pn_dictionary(server, user, password, database)

20180605的内容_迪克特.txt公司名称：Hello:a1:a1:0.999979

Big:a2:a2:0.999645

Apple:a3:a3:0.999486

表report\u pn_字典的结构：

^{pr2}$

哪里错了？如何修复？在