python df 轉換成SQL的寫法

原本的方式為逐筆寫入list，在join成SQL

table_name = "l5ab_eqp_port_status"

SQLS = []

for row in df.values:

    SQL = "('" + "','".join(row.astype("str")) + "')"

    SQLS.append(SQL)

SQL = "insert into " + table_name + " values " + ",".join(SQLS)

一行搞定

SQL = "insert into " + table_name + " values " + ",".join("('" + "','".join(row.astype("str")) + "')" for row in df.values)

筆記