使用字符串作为查询的python mysql问题

Question

所以我在我的程序中有一个字符串包含我想用来将行插入数据库的查询:

query = '"INSERT INTO new_test (test_name, IP, test_run_date, results_query_time, run_time) VALUES (%s, %s, %s, %s, %s)", ("new_test", "192.168.17.194", "143917160811", "12.4847829342", "46.1268320084")'

但是，当我执行命令时:

cursor.execute(query)

我收到这个错误

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 \'"INSERT INTO new_test (test_name, IP, test_run_date, results_query_time, run_tim\' at line 1')

我尝试了其他一些引号组合，但我终究无法弄清楚我做错了什么。有任何想法吗？谢谢!

Answer 1

你在查询的开头有一个额外的 "。那肯定会破坏它。看起来你想要:

# notice the extra ' around the %s
query = """INSERT INTO new_test 
              (test_name, IP, test_run_date, results_query_time, run_time) 
           VALUES ('%s', '%s', '%s', '%s', '%s')""" % \
           ("new_test", "192.168.17.194", "143917160811", 
           "12.4847829342", "46.1268320084")