首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >运行vi mysql python时Sql脚本出现错误

问运行vi mysql python时Sql脚本出现错误
EN

Stack Overflow用户
提问于 2017-01-03 12:52:15
回答 0查看 315关注 0票数 2

我编写了一个python脚本来执行我的sql脚本。当我使用source手动运行这个sql脚本时,它没有给我任何错误,只是警告,它完全执行为:

代码语言:javascript
复制
mysql> source the_actual_script.sql
Database changed
Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.29 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> 

但是当我尝试通过我的python代码运行它时:

代码语言:javascript
复制
import MySQLdb

db = MySQLdb.connect("aws.eu-central-1.rds.amazonaws.com","prod_user","pass","db_name")
cursor = db.cursor()
for line in open("/home/ubuntu/PATCHER/the_check_query.sql"):
  print  cursor.execute(line)
db.close()

它会给我错误:

代码语言:javascript
复制
test.py:8: Warning: PROCEDURE saas_neopostsa.temp_prod does not exist
  cursor.execute(line)
test.py:8: Warning: PROCEDURE saas_neopostsa.temp_prod_neopost does not exist
  cursor.execute(line)
test.py:8: Warning: PROCEDURE saas_neopostsa.temp_prod_neopostsa does not exist
  cursor.execute(line)
test.py:8: Warning: Unknown table 'temp_identity_neopostsa'
  cursor.execute(line)
test.py:8: Warning: Unknown table 'temp_identity'
  cursor.execute(line)
Traceback (most recent call last):
  File "test.py", line 8, in <module>
    cursor.execute(line)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1065, 'Query was empty')

有谁能帮我出什么事了吗?

EN

回答

页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/41436621

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档