今天入门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 问题解决