如何将缺少的物料导入数据表中

删除该表所有内容

TRUNCATE TABLE bas_product_copy1
 

查找缺少的数据

SELECT a.product_id as'物料编码',a.product_name as '物料名称',a.model as '规格型号',a.unit as '计量单位' from bas_product_copy1  a WHERE  not EXISTS(SELECT product_id from bas_product b where a.product_id = b.product_id)