DELETE wx
FROM zszx.EM_ENTPRISE_CONTACTS ec
RIGHT JOIN zszx.EM_ENTPRISE_CONTACTS_WX wx ON ec.ID = wx.CONTACTS_ID
WHERE (ec.MOBILE = '18672675202' OR wx.OPEN_ID = 'o3EXU1M9gBBtK69FnYEiTZmigp2o')
AND wx.APP_ID = 'wx07f5fb67545b9ad4';
这是mysql的写法吧,可以通过子查询的方式来实现间接地删除符合条件的记录。
使用什么软件,工具前,建议先看看说明文档
MERGE INTO zszx.EM_ENTPRISE_CONTACTS_WX wx
USING zszx.EM_ENTPRISE_CONTACTS ec
ON ( wx.CONTACTS_ID = ec.ID(+) )
WHEN MATCHED THEN
UPDATE SET ec.MOBILE = ec.MOBILE
DELETE
WHERE (ec.MOBILE = '18672675202' OR wx.OPEN_ID = 'o3EXU1M9gBBtK69FnYEiTZmigp2o')
AND wx.APP_ID = 'wx07f5fb67545b9ad4';
报什么错