Traceback (most recent call last):
File "D:/projectwc/test/dd.py", line 43, in <module>
effect_row = cursor.execute("insert into `222` set c={}".format(None))
File "C:\python\lib\site-packages\pymysql\cursors.py", line 166, in execute
result = self._query(query)
File "C:\python\lib\site-packages\pymysql\cursors.py", line 322, in _query
conn.query(q)
File "C:\python\lib\site-packages\pymysql\connections.py", line 835, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "C:\python\lib\site-packages\pymysql\connections.py", line 1019, in _read_query_result
result.read()
File "C:\python\lib\site-packages\pymysql\connections.py", line 1302, in read
first_packet = self.connection._read_packet()
File "C:\python\lib\site-packages\pymysql\connections.py", line 981, in _read_packet
packet.check_error()
File "C:\python\lib\site-packages\pymysql\connections.py", line 393, in check_error
err.raise_mysql_exception(self._data)
File "C:\python\lib\site-packages\pymysql\err.py", line 107, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (1054, "Unknown column 'None' in 'field list'")
import pymysql
# 创建连接
conn = pymysql.connect(host='192.168.72.135', port=3306, user='root', passwd='123456', db='test')
# 创建游标
cursor = conn.cursor()
# 执行SQL，并返回收影响行数
effect_row = cursor.execute("insert into `222` set c={}".format(None))
# 提交，不然无法保存新建或者修改的数据
conn.commit()
# 关闭游标
cursor.close()
# 关闭连接
conn.close()
解决办法：
把None 换成“Null”
effect_row = cursor.execute("insert into `222` set c={}".format("Null"))
还要注意字符串"Insert into 库.表 (`ID`, ....) values (123, 'Null'), ()" 如果要空值需要在替换一下
sql = sql.replace("'Null'", "Null")
ERR
NO: 256
TEXT: SQLSTATE[HY000]: General
error
: 1436 Thread stack ov
err
un: 4904 bytes used of a 131072 byte stack, and 128000 bytes needed. Use ‘mysqld -O thread_stack=#’ to specify a bigger stack.
According to the MySQL manual “The default (192KB) is large enough for normal operation. If the thr
pymysql
.
err
.Operational
Error
: (
1054
, "
Unknown
column
'None' in '
field
list
'")
解决
python
对mysql执行操作时报错：
pymysql
.
err
.Operational
Error
: (
1054
, “
Unknown
column
‘xxx’ in ‘where clause’”)
我发现我使用mysql往mysql数据库中插入数据的时候，少插入一个字段的数据，然后就想使用update语句把这一个字段的内容插进去：
sql = """UPDATE article set article_content = %s where id = %s""" %(content,article_
解决：
pymysql
.
err
.Operational
Error
: (
1054
, “
Unknown
column
‘None’ in ‘where clause’”)
下面是我代码中的sql语句
"SELECT
question_id,
question_type
lms_question
WHERE
company_id ={}
AND is_deleted = 0;".format (self.company_id)
运行后报错 ：
pymysql
.
err
.OperationalE.
使用flask搭建框架 连接mysql给表插入数据时报错
pymysq1.
err
.Operational
Error
:(
1054
, "
Unknown
column
'None' in '
field
list
'")
“字段列表中未知列为None”
原因分析：
原sql语句: sql = f"""insert into user values ({uname}, {pwd}, {mobile}, {email})"""
sql语句没获取到数据, 字段没有值
解决方案：
用
pymysql
向mysql插入图片数据时报错：
pymysql
.
err
.Operational
Error
: (
1054
, “
Unknown
column
‘xxx’ in ‘where clause’”)
# 修改单行数据
def db_update(self, sql, *args):
result = self.cur.execute(sql, args)
pymysql
.
err
.Operational
Error
: (
1054
, "
Unknown
column
'云南绿A生物工程有限公司福州分公司' in '
field
list
'")
问题截图如下：
经过我不断的查找和尝试，最后终于解决了问题：
答案：
pymysql
.
err
.Operational
Error
: (
1054
, "
Unknown
column
'云南绿A.
