我写了一个简单的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