SQL查詢中的Python列表作為參數我有一張蟒蛇名單，比如說我l = [1,5,8]我想編寫一個SQL查詢來獲取列表中所有元素的數據，比如select name from students where id = |IN THE LIST l|我該如何做到這一點？
3 回答
白衣染霜花
TA貢獻1796條經驗 獲得超10個贊
placeholder= '?' # For SQLite. See DBAPI paramstyle.placeholders= ', '.join(placeholder for unused in l)query= 'SELECT name FROM students WHERE id IN (%s)' % placeholders cursor.execute(query, l)
紫衣仙女
TA貢獻1839條經驗 獲得超15個贊
l = [1,5,8]l = tuple(l)params = {'l': l}cursor.execute('SELECT * FROM table where id in %(l)s',params)
慕妹3242003
TA貢獻1824條經驗 獲得超6個贊
select name from studens where id in (1, 5, 8)
l = [1, 5, 8]sql_query = 'select name from studens where id in (' + ','.join(map(str, l)) + ')'l = [1, 5, 8]sql_query = 'select name from studens where id in (' + ','.join((str(n) for n in l)) + ')'select name from studens where id = 1 or id = 5 or id = 8
sql_query = 'select name from studens where ' + ' or '.join(('id = ' + str(n) for n in l))添加回答
舉報
0/150
提交
取消