刪除MySQL中的JOIN下面是創建我的表的腳本：CREATE TABLE clients (
client_i INT(11),
PRIMARY KEY (client_id));CREATE TABLE projects (
project_id INT(11) UNSIGNED,
client_id INT(11) UNSIGNED,
PRIMARY KEY (project_id));CREATE TABLE posts (
post_id INT(11) UNSIGNED,
project_id INT(11) UNSIGNED,
PRIMARY KEY (post_id));在我的PHP代碼中，當刪除客戶端時，我希望刪除所有的項目帖子：DELETE FROM postsINNER JOIN projects ON projects.project_id = posts.project_idWHERE projects.client_id = :client_id;POST表沒有外鍵。client_id，只有project_id..我想刪除已通過的項目中的帖子。client_id.這是不可行的，因為沒有刪除的帖子。
3 回答
寶慕林4294392
TA貢獻2021條經驗 獲得超8個贊
posts
DELETE postsFROM postsINNER JOIN projects ON projects.project_id = posts.project_idWHERE projects.client_id = :client_id
滄海一幻覺
TA貢獻1824條經驗 獲得超5個贊
DELETE posts FROM postsINNER JOIN projects ON projects.project_id = posts.project_idWHERE projects.client_id = :client_id
table_name1table_name2
DELETE projects FROM posts INNER JOIN [...]
DELETE posts, projects FROM posts INNER JOIN [...]
order bylimit
DELETE p FROM posts as p INNER JOIN [...]
富國滬深
TA貢獻1790條經驗 獲得超9個贊
DELETE FROM posts USING posts, projects WHERE projects.project_id = posts.project_id AND projects.client_id = :client_id;
添加回答
舉報
0/150
提交
取消