擅长:python、mysql、java
<p>如果您使用的是MySQL和SQLAlchemy>;=1.2您可以使用SQLAlchemy使用<code>INSERT...ON DUPLICATE KEY UPDATE</code></p>
<pre class="lang-py prettyprint-override"><code>from sqlalchemy.dialects.mysql import insert
insert_stmt = insert(my_table).values(
id='some_existing_id',
data='inserted value')
on_duplicate_key_stmt = insert_stmt.on_duplicate_key_update(
data=insert_stmt.inserted.data,
status='U'
)
conn.execute(on_duplicate_key_stmt)
</code></pre>
<p>有关<a href="https://docs.sqlalchemy.org/en/13/dialects/mysql.html?highlight=duplicate#mysql-insert-on-duplicate-key-update" rel="nofollow noreferrer">docs</a>的更多信息</p>