删除数据库中联接的多个表中的记录 [英] Deleting Records in Joined Multiple Tables in a DataBase

问题描述

我该如何删除数据库中连接了6个表的特定记录.

Hi,

How can I delete a particular record in a DataBase where 6 tables are joined among each other.

推荐答案

试试这个...

例如:

Hi,
try this ...

for example :

Delete from a
inner join b on a.id = b.id
inner join c on a.id = c.id
inner join d on a.id = d.id
inner join e on d.id2 = e.id2
inner join f on e.id3 = f.id3
where b.type = '1' and d.number > 1000 and f.typevalue = 'x'

set cascade property ............... So that any reference in table also deleted

这篇关于删除数据库中联接的多个表中的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！