Tornado Documentation http://www.v2ex.com/tornado/ Tornado on GitHub https://github.com/facebook/tornado/ Tornado Gists http://tornadogists.org/
这是一个创建于 4924 天前的主题，其中的信息可能已经有所发展或是发生改变。
我写了一个简单的SQL语句：
return self.db.get("SELECT * FROM %s WHERE id = %s", get_table, int(get_id))
然后数据库中有个表叫 blog , 其中一条 id = 1，即 get_table = 'blog', get_id = 1
执行下来应该是
SELECT * FROM blog WHERE id = 1
可是报错如下：
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 ''blog' WHERE id = '1'' at line 1")
呃，应该是字符串连接问题？这一句SQL应该没什么问题啊，急求解。。orz
return self.db.get("SELECT * FROM %s WHERE id = %s", get_table, int(get_id))
然后数据库中有个表叫 blog , 其中一条 id = 1，即 get_table = 'blog', get_id = 1
执行下来应该是
SELECT * FROM blog WHERE id = 1
可是报错如下：
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 ''blog' WHERE id = '1'' at line 1")
呃，应该是字符串连接问题？这一句SQL应该没什么问题啊，急求解。。orz
 | 1 napoleonu 2012-07-05 22:28:45 +08:00  1 'blog' 多了两个单引号。 |
Select Language