="insert into tm_company_vehicle(MODEL_CODE, COMPANY_CODE) SELECT '536ED','"&A4&"' FROM dual where not exists(select MODEL_CODE,COMPANY_CODE from tm_company_vehicle where company_code='"&A4&"' and MODEL_CODE='536ED'); "
如果mysql没有查到数据,则新增,查到则不处理
="insert into tm_company_vehicle(MODEL_CODE, COMPANY_CODE) SELECT '536ED','"&A4&"' FROM dual where not exists(select MODEL_CODE,COMPANY_CODE from tm_company_vehicle where company_code='"&A4&"' and MODEL_CODE='536ED'); "
如果mysql没有查到数据,则新增,查到则不处理