SQL查詢中的Python列表作為參數(shù)我有一張蟒蛇名單，比如說我l = [1,5,8]我想編寫一個(gè)SQL查詢來獲取列表中所有元素的數(shù)據(jù)，比如select name from students where id = |IN THE LIST l|我該如何做到這一點(diǎn)？
3 回答
白衣染霜花
TA貢獻(xiàn)1796條經(jīng)驗(yàn) 獲得超10個(gè)贊
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貢獻(xiàn)1839條經(jīng)驗(yàn) 獲得超15個(gè)贊
l = [1,5,8]l = tuple(l)params = {'l': l}cursor.execute('SELECT * FROM table where id in %(l)s',params)
慕妹3242003
TA貢獻(xiàn)1824條經(jīng)驗(yàn) 獲得超6個(gè)贊
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))添加回答
舉報(bào)
0/150
提交
取消