cursor.execute()执行反斜杠的问题

ilikeqdi

#!/usr/bin/python
import MySQLdb
db=MySQLdb.connect(host="localhost",user="root",passwd="",db='test')
cursor=db.cursor()
cursor.execute(r'show databases \G;')
result=cursor.fetchall()
cursor.close()
print result

Traceback (most recent call last):
  File "./test.py", line 5, in ?
    cursor.execute(r'show databases \G;')
  File "build/bdist.linux-i686/egg/MySQLdb/cursors.py", line 174, in execute
  File "build/bdist.linux-i686/egg/MySQLdb/connections.py", line 36, in defaulterrorhandler
_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 '\\G' at line 1")

换成cursor.execute('show databases \\G;')
还是不行
谁有什么好办法??

anonymous0502

试了下貌似没问题：

1. #!/usr/bin/python
   
2. # -*- coding: utf-8 -*-
   
3. 
   
4. import sys
   
5. import MySQLdb
   
6. 
   
7. 
   
8. def myprint(obj, end='\n'):
   
9.     sys.stdout.write(str(obj) + end)
   
10. 
    
11. 
    
12. def main():
    
13.     db = MySQLdb.connect(host='localhost', user='root',
    
14.                          passwd='', db='mysql')
    
15.     cursor = db.cursor()
    
16.     cursor.execute(r'show databases')
    
17.     result = cursor.fetchall()
    
18.     myprint(result)
    
19. 
    
20.     cursor.execute(r'use test')
    
21.     cursor.execute(r'show tables')
    
22.     result = cursor.fetchall()
    
23.     myprint(result)
    
24. 
    
25.     cursor.close()
    
26. 
    
27. 
    
28. if __name__ == '__main__':
    
29.     main()
    
30.     myprint('done')
    

复制代码

ilikeqdi

cursor.execute(r'show databases \G;')

\G 是重点

anonymous0502

不懂\G的用处，只是看了下输出似乎比较美观一点。
换成直接执行操作系统命令呢

1. C:\>mysql -u root -p -e "show databases\G"
   
2. Enter password: *********
   
3. *************************** 1. row ***************************
   
4. Database: information_schema
   
5. *************************** 2. row ***************************
   
6. Database: mysql
   
7. *************************** 3. row ***************************
   
8. Database: test

复制代码

ilikeqdi

直接执行系统命令是可以实现的.就是想弄明白怎么才能cursor.execute() 包含\的语句,baidu,google了很久了,也没成功

ilikeqdi

如此冷清

anonymous0502

是啊，非常冷清，似乎都没见过这个板块的版主们来发帖回帖。