如果在任何一个表中都有id，是否可以从多表中删除id？

Question

是否可以从多个表中删除id (如果在任何一个表中可用)？就像-

"DELETE from EXCEL_ENTRY WHERE ID = '" & id & "' " _    
        & "union DELETE from DRAWING WHERE ID = '" & id & "' " _    
        & "union DELETE from DESIGN WHERE ID = '" & id & "' " _    
        & "union DELETE from ESTIMATE WHERE ID = '" & id & "'"  

先谢谢你...

Answer 1

您可以根据与您的表相关的相同id来使用联接查询

DELETE 
  ee.*,
  dr.*,
  de.*,
  e.* 
FROM
  EXCEL_ENTRY ee
  INNER JOIN DRAWING dr 
    ON (ee.id = dr.id) 
  INNER JOIN DESIGN de 
    ON (ee.id = de.id) 
  INNER JOIN ESTIMATE e 
    ON (ee.id = e.id) 
WHERE ee.ID = 'your_id' 

但更好的方法是使用cascade delete选项定义外键关系，注意您应该先在示例数据上尝试上面的delete查询，而不是直接在生产数据库上使用