Delete with Join in Laravel 4 Query Builder

Question

Is there a way to make a Delete with Inner Join on Laravel 4 through a query builder?

I have this sample query (sample query taken from this source.):

DELETE s.* FROM spawnlist s
INNER JOIN npc n ON s.npc_templateid = n.idTemplate
WHERE (n.type = "monster");

I've tried something like:

DB::table('spawnlist as s')
        ->join('npc as n', 's.npc_templateid', '=', 'n.idTemplate')
        ->where('n.type', 'monster')
        ->delete();

But the it seems that the join cannot be done here?

Canaan Etai · Accepted Answer · 2014-09-12 17:30:03Z

0

i think the best way is to us laravel's event, it is more easier and clean. you can perform same task like so:

DB::table('spawnlist')->delete();

then create a spawnlist event catch the deleting event and delete the other table like so:

Spawnlist::deleting( function ($sl) 
{
    DB::table('npc')->delete();
});

answered Sep 12, 2014 at 17:30

Canaan Etai

3,8052 gold badges23 silver badges18 bronze badges

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

3 Comments

Vainglory07 Over a year ago

how about the where clause?

Canaan Etai Over a year ago

You can still add it before the delete method like so... DB::table('spawnlist')->where('table.field', 'table.field')->delete();

luukvhoudt Over a year ago

Wouldn't this cause the DB facade to query and commit twice to the database?

Collectives™ on Stack Overflow

Delete with Join in Laravel 4 Query Builder

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related