Deleting from multiple MySQL Database table

Question

Why is it when I delete data from multiple tables in MySQL nothing happens? My scenario is when I delete a school from university all the courses, faculty and students enrolled in that school is also deleted.

Here's how I do it

DELETE FROM university, courses, faculty, students 
INNER JOIN university 
INNER JOIN courses 
INNER JOIN faculty 
INNER JOIN students ON university.id = courses.university_id
AND  courses.id = faculty.courses_id
AND faculty.id = students.faculty_id 
WHERE university.id = :id

WHERE :id = id from PHP code.

Reference: Mysql - delete from multiple tables with one query and http://www.mysqltutorial.org/mysql-delete-statement.aspx

Why are you mixing join styles?

Strawberry
– Strawberry

2014-07-28 18:26:28 +00:00
Commented Jul 28, 2014 at 18:26 — Strawberry
– Strawberry, Commented Jul 28, 2014 at 18:26

juergen d · Accepted Answer · 2014-07-28 18:26:11Z

2

This is the syntax to use

DELETE university, courses, faculty, students 
FROM university 
INNER JOIN courses ON university.id = courses.university_id
INNER JOIN faculty ON courses.id = faculty.courses_id
INNER JOIN students ON faculty.id = students.faculty_id 
WHERE university.id = :id

answered Jul 28, 2014 at 18:26

juergen d

205k40 gold badges303 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Deleting from multiple MySQL Database table

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related