今天在删除连表数据时,总结了下连表删除的方法
- DELETE Resultdoc,Systemfile FROM Resultdoc,Systemfile WHERE savePath = '12' AND Resultdoc.resDocFileCode = Systemfile.id
DELETE Resultdoc FROM Resultdoc,Systemfile WHERE savePath = '12' AND Resultdoc.resDocFileCode = Systemfile.id
只会删除Resultdoc表中的数据。
- DELETE FROM ResultDoc WHERE resDocFileCode in(select id from Systemfile where savepath = ‘12’ AND resultdoc.resDocFileCode = systemfile.id) 删除Resultdoc表中的数据。