擅长:python、mysql、java
<P>考虑^ {CD1>}+^ {CD2>}和^ {CD3>},^ {< CD4>}:</P>
<pre class="lang-py prettyprint-override"><code>query_insert_tmp = """
INSERT INTO <my_table>
VALUES (?, ?, ?, ?)
"""
sql_data = edited_df.to_numpy().tolist()
cursor.executemany(query_insert_tmp, sql_data)
</code></pre>