list = [u'ABC', u'DEF', u'GHI']list = str(map(str, list))list = list.replace('[', '{').replace(']', '}').replace(''', '"')query = '''update "aTable" SET "Test" = '%s'''' %(list)print query会导致
update "aTable" SET "Test" = '{"ABC", "DEF", "GHI"}'
list = [u'ABC', u'DEF', u'GHI']list = str(map(str, list))list = list.replace('[', '{').replace(']', '}').replace(''', '"')query = '''update "aTable" SET "Test" = '%s'''' %(list)print query会导致
update "aTable" SET "Test" = '{"ABC", "DEF", "GHI"}'名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
