导出select * into outfile from A where left(dt,4) < '2014'导入load data infile 'outfile' into table A
delete FROM rv_licai RIGHT OUTER JOIN rv_duifu ON rv_duifu.licaiid = rv_licai.id WHERE rv_licai.shenhe =1 AND rv_licai.yiduifu =1 AND left( ldate, 4 ) < '2014' 这句sql会把rv_licai这个表里的相关数据删掉?
DELETE a FROM rv_licai a RIGHT OUTER JOIN rv_duifu ON rv_duifu.licaiid = a.id WHERE a.shenhe =1 AND a.yiduifu =1 AND LEFT( ldate, 4 ) < '2014'
我只想删除rv_duifu表里的是不是只要DELETE b FROM rv_licai a RIGHT OUTER JOIN rv_duifu b ON b.licaiid = a.id WHERE a.shenhe =1 AND a.yiduifu =1 AND LEFT( ldate, 4 ) < '2014' ??
我只想删除rv_duifu表里的 DELETE b FROM rv_licai a inner JOIN rv_duifu b ON b.licaiid = a.id WHERE a.shenhe =1 AND a.yiduifu =1 AND LEFT( ldate, 4 ) < '2014'
导出select * into outfile from A where left(dt,4) < '2014'导入load data infile 'outfile' into table A
RIGHT OUTER JOIN rv_duifu ON rv_duifu.licaiid = rv_licai.id
WHERE rv_licai.shenhe =1
AND rv_licai.yiduifu =1
AND left( ldate, 4 ) < '2014' 这句sql会把rv_licai这个表里的相关数据删掉?
RIGHT OUTER JOIN rv_duifu ON rv_duifu.licaiid = a.id
WHERE a.shenhe =1
AND a.yiduifu =1
AND LEFT( ldate, 4 ) < '2014'
RIGHT OUTER JOIN rv_duifu b ON b.licaiid = a.id
WHERE a.shenhe =1
AND a.yiduifu =1
AND LEFT( ldate, 4 ) < '2014' ??
DELETE b FROM rv_licai a
inner JOIN rv_duifu b ON b.licaiid = a.id
WHERE a.shenhe =1
AND a.yiduifu =1
AND LEFT( ldate, 4 ) < '2014'