[FIXED] How to run raw SQL query without any expected result in Laravel 6?

Issue

In Laravel 6.x is any way to run raw SQL query without any expected result?

Like this one:

$query = 'INSERT INTO product_copys (SELECT '. implode(',', $myColumArray) .' FROM products)';

I tried this:

DB::run($query);

...but it said FatalThrowableError: Call to protected method Illuminate\Database\Connection::run() from context 'Illuminate\Database\DatabaseManager'.

Any idea?

Solution

did you try DB::statement() ?

$query = 'INSERT INTO product_copys (SELECT '. implode(',', $myColumArray) .' FROM products)';

DB::statement($query);

Answered By - Sok Hai

Answer Checked By - Willingham (PHPFixing Volunteer)