擅长:python、mysql、java
<p>您可以删除两端的单引号,然后将“| |”拆分为两个字符串</p>
<p>这是我的实施方式</p>
<pre><code>>>> first, second = mylist[0][1:-1].split('||')
>>> f'INSERT INTO CUSTOMER (app_s3) VALUES ({first}||{second})'
"INSERT INTO CUSTOMER (app_s3) VALUES ((select envrnmnt_parm_value from envrnmnt_parm where module_nm='Global')||home/inbound/travel/IMS/)"
</code></pre>