python mysql 进修笔记

今天入门python 搞了好久没搞定idea 集成 python并导入指定模块  后来搞定了还出现以下错误

Traceback (most recent call last):
  File "/Users/gezehao/work/workspace/testpy/templates/mysqltest/mysqlget.py", line 8, in <module>
    cursor.execute('select * from wm_user where id = %s', 1)
  File "build/bdist.macosx-10.9-intel/egg/mysql/connector/cursor.py", line 507, in execute
  File "build/bdist.macosx-10.9-intel/egg/mysql/connector/connection.py", line 722, in cmd_query
  File "build/bdist.macosx-10.9-intel/egg/mysql/connector/connection.py", line 640, in _handle_result
mysql.connector.errors.ProgrammingError: 1064 (42000): 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' at line 1

代码如下：

cursor.execute('select * from wm_user where id = %s', 1)

上了stackoverflow 知道原来代码有问题  execute方法传入的是一个tuple对象，故改成cursor.execute('select * from wm_user where id = %s', (1,))  

OK 问题解决