mysql - 单个SQL查询删除两个表中的记录

Question

这个问题已经有答案了:

How to delete from multiple tables in MySQL? (7 个回答)

已关闭 7 年前。

这些是我的表格:

tbl_student (studID,Firstname) 

我的学生是priid

finger_template(Detail_ID,FingerprintMask)

我要删除tbl_student中的记录和finger_template 。这是我的查询:

command = New MySqlCommand("DELETE from tbl_student where studid='" & priid & "'", connection, transaction)

希望有人帮忙

Answer 1

表:tbl_student

+-------------+-----------+
| studID (PK) | Firstname |
+-------------+-----------+
| **000001**  | John      |
+-------------+-----------+

表:finger_template

+----------------+-----------------+-------------+
| Detail_ID (PK) | FingerprintMask | studID (FK) |
+----------------+-----------------+-------------+
| 000001         | SampleMask      | **000001**  |
+----------------+-----------------+-------------+

如果 tbl_student studID PK 链接到 Finger_template stuID FK您只需删除 studID PK，FK 也会被删除DELETE FROM tbl_student WHERE StudID=000001