nibuyaoshiwang的博客

# 子查询select table_A_id as tableA.table_A_id, table_B_pass as tableB.pass, max_table_A_id as max(tableA.id) from tableA left outer join tableC ON tableC.xx_id = tableA.table_A_id left outer join tableB ON tableB.id = tableC.passwd_idleft outer join tabl

考虑sqlalchemy的批量插入性能问题，参考了这位博主的博客，发现如下性能最优：db.session.execute( Device.__table__.insert(), process_data.get("insert_data"))db.session.commit()但是如果表中含有json字段想这样批量插入，尝试了各种写法都是不行的。这里推荐另一种方法可以批量插入json类型，而且性能也是不错的。db.session.bulk_insert_mappings(