Traceback (most recent call last):
File "load_juzhi_data.py", line 44, in <module>
output_main(file_jz)
File "load_juzhi_data.py", line 29, in output_main
load_data_mysql(mysql)
File "load_juzhi_data.py", line 13, in load_data_mysql
cur.execute(mysql)
File "D:\Anaconda2\lib\site-packages\pymysql\cursors.py", line 146, in execute
result = self._query(query)
File "D:\Anaconda2\lib\site-packages\pymysql\cursors.py", line 296, in _query
conn.query(q)
File "D:\Anaconda2\lib\site-packages\pymysql\connections.py", line 781, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "D:\Anaconda2\lib\site-packages\pymysql\connections.py", line 942, in _read_query_result
result.read()
File "D:\Anaconda2\lib\site-packages\pymysql\connections.py", line 1138, in read
first_packet = self.connection._read_packet()
File "D:\Anaconda2\lib\site-packages\pymysql\connections.py", line 906, in _read_packet
packet.check_error()
File "D:\Anaconda2\lib\site-packages\pymysql\connections.py", line 367, in check_error
err.raise_mysql_exception(self._data)
File "D:\Anaconda2\lib\site-packages\pymysql\err.py", line 120, in raise_mysql_exception
_check_mysql_exception(errinfo)
File "D:\Anaconda2\lib\site-packages\pymysql\err.py", line 112, in _check_mysql_exception
raise errorclass(errno, errorvalue)
pymysql.err.ProgrammingError: (1064, u'')
##########################################################################
注意当mysql 出现这个错误,很可能是因为 在字段内容中出现 单引号或双引号,需插入前处理。
pymysql.err.ProgrammingError: (1036, u'') 表的字符集的问题