Convert a MySql query into Laravel

Question

My SQL query is:

SELECT* FROM cubes LEFT JOIN xkvs ON cubes.id=xkvs.cube_id WHERE xkvs.cube_id IS NULL

I tried the method from the laravel documentation but always get an error, that xkvs.cubes_id is an unknown column.

How do I write this correctly?

This is my try:

$cubes=DB::table('cubes')
        ->leftjoin('xkvs', function ($join) {
            $join->on('cubes.id', '=', 'xkvs.cubes_id')
                 ->where('xkvs.cubes_id', '=', null);
        })
        ->get();

Can you try bpaste.net/show/9aa8b948eae2 ? I am posting this as a comment since I've never used laravel, nor eloquent in my life yet. Just a wild guess from the docs. — xate
– xate, Commented Jul 2, 2018 at 10:58

eisbehr · Accepted Answer · 2018-07-02 11:01:41Z

2

DB::table('cubes')
    ->select('cubes.*')
    ->leftjoin('xkvs', 'cubes.id', '=', 'xkvs.cubes_id')
    ->whereNull('xkvs.cube_id')
    ->get();

edited Jul 2, 2018 at 11:01

eisbehr

12.5k8 gold badges42 silver badges65 bronze badges

answered Jul 2, 2018 at 11:00

Nguyễn Anh Đức

1232 silver badges5 bronze badges

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

Collectives™ on Stack Overflow

Convert a MySql query into Laravel

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