python链接mysql出错：_mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax;

最新推荐文章于 2022-01-22 15:49:22 发布
最新推荐文章于 2022-01-22 15:49:22 发布
阅读量5.1k 收藏
点赞数 1
CC 4.0 BY-SA版权
分类专栏： mysql数据库 python学习
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/Homewm/article/details/81669570
本文记录了一个项目中遇到的MySQL语法错误问题及解决过程。通过排查发现是由于SQL语句中的单双引号使用不当导致，最终通过修正引号用法解决了问题。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

这个问题发生在我做的项目中的一个内容。处理数据，然后写入mysql数据库中。

报错情况：

_mysql_exceptions.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 's qpopper allows remote attackers to gain root access using a long PASS command.' at line 1")

解决思路：

刚开始报错出现下面这种情况，于是我就各种百度，然后也没查不出来具体的原因。

然后我就把要产生的待处理的数据在Navicat中插入看看能否正常执行。

这不是老问题吗？单双引号的问题！！！

于是就又找到了我另外一篇博客：https://blog.youkuaiyun.com/Homewm/article/details/81665511

结果问题就解决了！！！

 

 

《Python基础教程》内容总览篇（持续更新中）
weixin_43178406的博客
08-26 30万+
大家好，我是爱编程的喵喵。双985硕士毕业，现担任全栈工程师一职，热衷于将数据思维应用到工作与生活中。从事机器学习以及相关的前后端开发工作。曾在阿里云、科大讯飞、CCF等比赛获得多次Top名次。现为优快云博客专家、人工智能领域优质创作者。喜欢通过博客创作的方式对所学的知识进行总结与归纳，不仅形成深入且独到的理解，而且能够帮助新手快速入门。个人精心开设的《Python基础课程》专栏订阅量接近900，帮助不少同学解决了Bug。
django3.x 不支持mysql5.5及以下版本
qq_42732013的博客
06-02 543
问题描述： 学习django框架，执行python3.8 manage.py migrate创建数据库时，产生报错 System check identified some issues: WARNINGS: ?: (mysql.W002) MySQL Strict Mode is not set for database connection 'default' HINT: MySQL's Strict Mode fixes many data integrity proble...
Python：使用MySQLdb.connect出现错误：_mysql_exceptions.OperationalError: (2002,
qq_42609381的博客
07-28 4593
使用Python脚本连接数据时，遇到以下错误： [root@Joe system]# python test.py   File "test.py", line 149, in <module>     db=MySQLdb.connect("localhost", "root", "kdc", "nms")   File "/usr/lib64/python2.7/
python连接Mysql错误：_mysql_exceptions.OperationalError: (1054, "Unknown column 'CVE' in 'field lis解决办法
果冻先生的专栏
08-14 1万+
_mysql_exceptions.OperationalError: (1054, "Unknown column 'CVE' in 'field list'") （1）错误：#1054 - Unknown column 'CVE' in 'field list'   primaryTable_info_insert = "INSERT INTO primaryTable (cve_...
[Err] 1064 - You have an error in your SQL syntax; mysql 问题解决
wyx100的专栏
08-15 2万+
[Err] 1064 - You have an error in your SQL syntax; mysql 问题解决 原因： sql语句后面没有写“；”
MySQLdb._exceptions.ProgrammingError: (1064, ＜NULL＞)
w710537643的博客
09-28 769
查了变天的问题 怀疑是 字符串格式的问题 当 使用 单引号时报 MySQLdb._exceptions.ProgrammingError: (1064, <NULL>) sql3 = 'update mysite_yaoinfos set yaodian="{}" where id>=11133 and name = "{}"'.format(i["yaodian"], i["name"]) 使用双引号 报 MySQLdb._exceptions.ProgrammingError: (
sql语句 异常 Err] 1064 - You have an error in your SQL syntax； check the manual that corresponds to your
Nimitz_33的博客
10-28 758
sql语句 异常 Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your sql语句 异常 Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your 报错原因是sql语句写错了。 字段要是变了颜色必然不会出错，最肯出的错误是 1、除了最后一条语句是否每一条一
django连接mysql数据库1064错误
画流_博客
12-07 1781
错误信息如下 django.db.utils.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 ‘SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED’ at line 1”) 原因：
(.venv) PS D:\pycharm\daima\fg\login_reg> python manage.py migrate Operations to perform: Apply all migrations: admin, auth, contenttypes, login, sessions Running migrations: Traceback (most recent call last): File "D:\pycharm\daima\fg\.venv\Lib\site-packages\django\db\backends\utils.py", line 82, in _execute return self.cursor.execute(sql) ^^^^^^^^^^^^^^^^^^^^^^^^ File "D:\pycharm\daima\fg\.venv\Lib\site-packages\django\db\backends\mysql\base.py", line 71, in execute return self.cursor.execute(query, args) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "D:\pycharm\daima\fg\.venv\Lib\site-packages\pymysql\cursors.py", line 153, in execute result = self._query(query) ^^^^^^^^^^^^^^^^^^ File "D:\pycharm\daima\fg\.venv\Lib\site-packages\pymysql\cursors.py", line 322, in _query conn.query(q) File "D:\pycharm\daima\fg\.venv\Lib\site-packages\pymysql\connections.py", line 563, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "D:\pycharm\daima\fg\.venv\Lib\site-packages\pymysql\connections.py", line 825, in _read_query_result result.read() File "D:\pycharm\daima\fg\.venv\Lib\site-packages\pymysql\connections.py", line 1199, in read first_packet = self.connection._read_packet() ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "D:\pycharm\daima\fg\.venv\Lib\site-packages\pymysql\connections.py", line 775, in _read_packet packet.raise_for_error() File "D:\pycharm\daima\fg\.venv\Lib\site-packages\pymysql\protocol.py", line 219, in raise_for_error err.raise_mysql_exception(self._data) File "D:\pycharm\daima\fg\.venv\Lib\site-packages\pymysql\err.py", line 150, 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 '(6) NOT NULL)' at line 1") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "D:\pycharm\daima\fg\.venv\Lib\site-packages\django\db\migrations\recorder.py", line 67, in ensure_schema editor.create_model(self.Migration) File "D:\pycharm\daima\fg\.venv\Lib\site-packages\django\db\backends\base\schema.py", line 307, in create_model self.execute(sql, params or None) File "D:\pycharm\daima\fg\.venv\Lib\site-packages\django\db\backends\base\schema.py", line 137, in execute cursor.execute(sql, params) File "D:\pycharm\daima\fg\.venv\Lib\site-packages\django\db\backends\utils.py", line 99, in execute return super().execute(sql, params) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "D:\pycharm\daima\fg\.venv\Lib\site-packages\django\db\backends\utils.py", line 67, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "D:\pycharm\daima\fg\.venv\Lib\site-packages\django\db\backends\utils.py", line 76, in _execute_with_wrappers return executor(sql, params, many, context) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "D:\pycharm\daima\fg\.venv\Lib\site-packages\django\db\backends\utils.py", line 80, in _execute with self.db.wrap_database_errors: File "D:\pycharm\daima\fg\.venv\Lib\site-packages\django\db\utils.py", line 89, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "D:\pycharm\daima\fg\.venv\Lib\site-packages\django\db\backends\utils.py", line 82, in _execute return self.cursor.execute(sql) ^^^^^^^^^^^^^^^^^^^^^^^^ File "D:\pycharm\daima\fg\.venv\Lib\site-packages\django\db\backends\mysql\base.py", line 71, in execute return self.cursor.execute(query, args) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "D:\pycharm\daima\fg\.venv\Lib\site-packages\pymysql\cursors.py", line 153, in execute result = self._query(query) ^^^^^^^^^^^^^^^^^^ File "D:\pycharm\daima\fg\.venv\Lib\site-packages\pymysql\cursors.py", line 322, in _query conn.query(q) File "D:\pycharm\daima\fg\.venv\Lib\site-packages\pymysql\connections.py", line 563, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "D:\pycharm\daima\fg\.venv\Lib\site-packages\pymysql\connections.py", line 825, in _read_query_result result.read() File "D:\pycharm\daima\fg\.venv\Lib\site-packages\pymysql\connections.py", line 1199, in read first_packet = self.connection._read_packet() ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "D:\pycharm\daima\fg\.venv\Lib\site-packages\pymysql\connections.py", line 775, in _read_packet packet.raise_for_error() File "D:\pycharm\daima\fg\.venv\Lib\site-packages\pymysql\protocol.py", line 219, in raise_for_error err.raise_mysql_exception(self._data) File "D:\pycharm\daima\fg\.venv\Lib\site-packages\pymysql\err.py", line 150, in raise_mysql_exception raise errorclass(errno, errval) django.db.utils.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 '(6) NOT NULL)' at line 1") During handling of the above exception, another exception occurred: Traceback (most recent call last): File "D:\pycharm\daima\fg\login_reg\manage.py", line 21, in <module> main() File "D:\pycharm\daima\fg\login_reg\manage.py", line 17, in main execute_from_command_line(sys.argv) File "D:\pycharm\daima\fg\.venv\Lib\site-packages\django\core\management\__init__.py", line 381, in execute_from_command_line utility.execute() File "D:\pycharm\daima\fg\.venv\Lib\site-packages\django\core\management\__init__.py", line 375, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "D:\pycharm\daima\fg\.venv\Lib\site-packages\django\core\management\base.py", line 323, in run_from_argv self.execute(*args, **cmd_options) File "D:\pycharm\daima\fg\.venv\Lib\site-packages\django\core\management\base.py", line 364, in execute output = self.handle(*args, **options) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "D:\pycharm\daima\fg\.venv\Lib\site-packages\django\core\management\base.py", line 83, in wrapped res = handle_func(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "D:\pycharm\daima\fg\.venv\Lib\site-packages\django\core\management\commands\migrate.py", line 232, in handle post_migrate_state = executor.migrate( ^^^^^^^^^^^^^^^^^ File "D:\pycharm\daima\fg\.venv\Lib\site-packages\django\db\migrations\executor.py", line 91, in migrate self.recorder.ensure_schema() File "D:\pycharm\daima\fg\.venv\Lib\site-packages\django\db\migrations\recorder.py", line 69, in ensure_schema raise MigrationSchemaMissing("Unable to create the django_migrations table (%s)" % exc) django.db.migrations.exceptions.MigrationSchemaMissing: Unable to create the django_migrations table ((1064, "You hav e an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL)' at line 1"))
最新发布
06-03
在 Django 项目中，当执行 `python manage.py migrate` 命令时，如果出现 SQL 语法错误 `(1064, "You have an error in your SQL syntax")`，通常是由于以下原因之一导致的： #### 数据库版本不兼容 Django 的某些...
【Error Handling and Debugging】: Common Issues and Solutions for Operating MySQL with Python
# 1. Basic Interaction between Python and MySQL ... As a widely-used dynamic programming language, Python boasts clear and concise syntax and is easy to learn. It excels in various fields such as d
在scrapy爬取微博热评时出现MySQLdb._exceptions.ProgrammingError错误
m0_52111803的博客
10-21 327
问题代码： MySQLdb._exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to you r MySQL server version for the right syntax to use near 'read,mention) values ('家长偏心对孩子的影响有多大',15424499,5655)' at line 1")
错误代码： 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL ser
reee112的博客
10-29 6085
删除时,要在delete 与 from 之间加上 表的别名,这样用别名才不会报错 DELETE t FROM iot_bustype_sensortype_relation t WHERE id IN (1,2)
虚拟机运行时mysql_在虚拟机中运行测试时Django MySQL错误
weixin_28747829的博客
02-12 210
我有一个Django应用程序在我的本地python3.6版本上运行得很好，我想确保它在其他地方安装时也能做到。在为此，我创建了一个virtualenv，使用的Python版本在全局范围内运行良好，但没有任何包：virtualenv --no-site-packages --python=$(which python3.6) clear_envsource clear_env/bin/activat...
Error:1064 You have an error in your SQL syntax； check the manual that corresponds to your MySQL
Ice Point.
01-22 4894
错误代码： 1064 创建表的时候报这个错误，其实一般这种错误就是写sql 的时候符号有错误。 这时候我们单独运行特定的一句话，就会发现具体的错误点在哪。 1064错误简单点就是你的sql语句格式有问题，符号的错误。 ...
解决mysql报错信息1064, You have an error in your SQL syntax
热门推荐
何必说
05-09 4万+
已知mysql的报错信息为：1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server MySQL的1064错误是SQL语句写的有问题时出现的，即SQL的语法错误。那么一定是你的sql语句写的不规范或者写错了，可以看看关键字段是否有什么问题（与mysql自带字段冲突等），或者某一个函数用错等，总之就是sql语句写的有错误，可以单独提出来放到可视化查询工具审查审查 ...
SQL错误（1064）：You have an error in your SQL syntax; check the manual that corresponds to your MySQL
落队的飞行兵
12-24 4万+
在 mysql 中报错： SQL错误（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 'VARCHAR2(32) NOT NULL comment 'P', Ywlx number(5) comment '业务类型', Ywid' at line 2
误用关键字-_mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax;
helloxiaozhe的博客
08-09 2万+
_mysql_exceptions.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 'current_date,knowledge_level,grade_group_id,subject_id,current_arrive_level,c
python MySQLdb连接mysql失败 mysql_exceptions.OperationalError: (2002, "Can't connect to local MySQL
QZC295919009的专栏
01-12 1万+
我这边产生这个错误是因为在MySQLdb_connect中填写的是远程mysql数据库所在服务器的域名，而填写改为服务器的IP后成功运行。 -----------------------------------------------------------------------------------------------------------------------------
Error Code : 1064 You have an error in your SQL syntax;
iUserWang
09-20 6368
Query : " where ru.userid =" Error Code : 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 ’ where ru.userid =...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值