mysql unescape解码_python mysql escape\n（简单语法错误）

最新推荐文章于 2023-10-30 17:14:53 发布

华府萝贝贝

最新推荐文章于 2023-10-30 17:14:53 发布

阅读量187

点赞数

文章标签： mysql unescape解码

本文链接：https://blog.csdn.net/weixin_30863465/article/details/114766692

版权

我想使用这个python命令将mysql数据库导出到一个.csv文件中。在cursor.execute("""SELECT * INTO OUTFILE 'NullServids.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\\n' FROM accounts WHERE srvid is NULL""")

但它返回以下语法错误。在

^{pr2}$

所以我尝试不转义换行符，当我复制并粘贴到MySQL中时，它显然起作用。在cursor.execute("""SELECT * INTO OUTFILE 'NullServids.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' FROM accounts WHERE srvid is NULL""")

但我有个错误：_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 '' FROM accounts WHERE srvid is NULL' at line 2")

所以我的问题是，怎样才能正确地转义换行符，以便在cursor.execute()调用中正确地解释换行符？我在谷歌上搜索了一下，却找不到答案，这让我很尴尬。在