如何在MySQL中使用变量.Python脚本

Question

我正在尝试优化这个代码块以使用单个查询而不是一遍又一遍地循环。

while not (dataX):
            i += 1
            this_id = '/'.join(this_id.split('/')[0:-i])
            if not this_id:
                break
            else:
                dataX = db.conn[db_read].query("SELECT x AS xX FROM link WHERE _deleted = 0 AND _ref = %s AND _ntype = 'code' LIMIT 1;", data = (this_id,))

我想将其子句与包含所有可能子字符串的变量使用，但我无法正常工作。

this_id_list = "'/a/b/c/d/e' , '/a/b/c/d', '/a/b/c', '/a/b', '/a'"
result = db.conn[db_read].query("SELECT x AS xX FROM link WHERE _deleted = 0 AND _ref IN($this_id_list)")

知道我在做什么错以及如何解决？我真的很感谢任何投入！这是一个python脚本。

Answer 1

this_id_list = "'/a/b/c/d/e' , '/a/b/c/d', '/a/b/c', '/a/b', '/a'"

这应该是字符串