1、删除子表数据（联合查询删除）
delete t1
from RR.tblOeWkPublicOrderItem as t1
inner join RR.tblOeWkPublicOrderHeader t2 on t1.tran_code = t2.tran_code and t1.request_no = t2.request_no
where create_date < @min_date;
2、
1、删除子表数据（联合查询删除）
delete t1
from RR.tblOeWkPublicOrderItem as t1
inner join RR.tblOeWkPublicOrderHeader t2 on t1.tran_code = t2.tran_code and t1.request_no = t2.request_no
where create_date < @min_date;
2、
本文标题：MYSQL笔记
本文链接：https://www.haomeiwen.com/subject/zheaddtx.html
网友评论