删除没有关联关系的数据

最新推荐文章于 2023-05-22 11:29:41 发布

dinglongpei8983

最新推荐文章于 2023-05-22 11:29:41 发布

阅读量298

点赞数

原文链接：http://www.cnblogs.com/yanjunwu/p/3492818.html

版权

1.delete ???(要删的数据所在表的别名,必须有) t_gahiga_ahighai ??? left join t_gtahiaigiha_aghiahgia *** on --- left join ...(省略号表示这种left join 的关系)... where ...(这里是真正的外界传入的条件)...

例子:

public void deleteCarTypeSyn2(int dealerId,String sids) throws Exception{
  StringBuffer sql = new StringBuffer();
  sql.append("delete dct from t_dealer_car_type dct left join t_car_type ct on dct.tid=ct.id left join t_car_series cs on ct.sid=cs.id where dct.dealerId=").append(dealerId);
  sql.append(" and cs.id in (").append(sids).append(")");
  MySqlHelper ms = new MySqlHelper();
  ms.connect();
  ms.update(sql.toString(), new Object[]{});
  ms.commit();
  ms.close();
}

转载于:https://www.cnblogs.com/yanjunwu/p/3492818.html