批量插入

• Z时代
• 2024-01-10
• 分类：综合

1、在数据库查出所需列

2、复制insert语句

3、excel准备对应的数据

4、insert语句结合公式生成对应的insert语句

="INSERT INTO `asset_manage_05_28`.`fee_fee_receiving_detail` (`id`, `receiving_id`, `fee_type`, `receiving_amount`, `org_id`, `user_id`, `create_by`, `modify_by`) VALUES ("&A24&","&B24&","&C24&","&D24&","&E24&","&F24&",""&G24&"",""&H24&"");"

以上是 批量插入 的全部内容， 来源链接： utcz.com/z/534999.html