Delete query sql

Question

I'm trying to delete the session and exercises related to that session using:

$delete_session =

"DELETE FROM sessions, exercises 
USING sessions 
INNER JOIN exercises 
ON sessions.session_id = exercises.session_id 
WHERE sessions.session_id= '$delete_id'";

The above query works if there are exercises linked to the session but doesn't fire if the session has no exercises.

Can I use the above query and below one together?

"DELETE FROM sessions WHERE session_id= '$delete_id'";

How could I get it that the session will delete with or without exercises linked to it?

Try with LEFT JOIN

Lukasz Szozda
– Lukasz Szozda

2015-09-19 16:01:55 +00:00
Commented Sep 19, 2015 at 16:01 — Lukasz Szozda
– Lukasz Szozda, Commented Sep 19, 2015 at 16:01

Hassan Naqvi · Accepted Answer · 2015-09-20 09:27:01Z

1

You should use LEFT INNER JOIN

$delete_session =
"DELETE FROM sessions, exercises 
USING sessions 
LEFT INNER JOIN exercises 
ON sessions.session_id = exercises.session_id 
WHERE sessions.session_id= '$delete_id'";

edited Sep 20, 2015 at 9:27

answered Sep 19, 2015 at 16:07

Hassan Naqvi

4236 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

Delete query sql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related